Excel Functions
- by dwyane
=MAX(SUM(A1:A5))
How do i incorporate the above formula into
=IF(
AND(
$H$14<F22, F22<=($H$14+$H$15)
),
$I$15,
IF(
AND(
$H$14+$H$15<F22, F22<($H$14+$H$15+$H$16)
),
$I$16,
IF(
AND(
$H$14+$H$15+$H$16<F22, F22<=($H$14+$H$15+$H$16+$H$17)
),
$I$17,
$I$14
)
)
)
It keeps running a circular reference error. Help!
The sum value shouldnt exceed 150. If exceed, then replace the cell with zero value.
