More than 16 nested IFs!!!!
Meltad wrote...
....
EG If X20 and AA20, AG2=0 and AJ20, lowest margin is displayed as value
in AA2 but should be AJ2
....
My formula would use AA2 in this case because *YOUR* original formula
would use AA2 in this case. That is, *YOUR* original formula begins
=IF(AND($P20,$AA20),
((($AA2-$P2))/$AA2),
IF(AND($P2=0,$AA20),
((($AA2-$Q2))/$AA2),
If AA20, your original formula wouldn't check whether any other value
in cells X2, AG2, AJ2, AP2, AS2, AY5, BB2 is greater than zero or not.
If that's not what you intended, then your original formula was wrong,
and you need to provide corrected specs.
|