# Formula HELp

D

#### DP7

Why does the below formula not work? Any help would be greatly appreciated.
Thanks

D

#### David Biddulph

Which version of Excel? If before 2007, I guess your problem is too many
layers of nesting.

Try to rearrange to reduce the nesting depth, such as
=IF(AN10="AIR",IF(AX10="Fri",AH10+3,IF(AX10="Sat",AH10+2,IF(OR(AX10="Mon",AX10="Tue",AX10="Wed",AX10="Thu",AX10="Sun"),AH10+1,""))),IF(AX10="Mon",AH10+4,IF(AX10="Tue",AH10+6,IF(AX10="thu",AH10+5,IF(AX10="fri",AH10+5,IF(AX10="sun",AH10+5,IF(AX10="Will
or go another stage to
=IF(AN10="AIR",IF(AX10="Fri",AH10+3,IF(AX10="Sat",AH10+2,IF(OR(AX10="Mon",AX10="Tue",AX10="Wed",AX10="Thu",AX10="Sun"),AH10+1,""))),IF(AX10="Mon",AH10+4,IF(AX10="Tue",AH10+6,IF(OR(AX10="thu",AX10="fri",AX10="sun"),AH10+5,IF(AX10="Will

[With either of these, as in your original, it doesn't specifically cover
"Wed" or "Sat" if AN10 is not "AIR", so presumably this is intended to
return a blank result?]

An alternative approach for reducing nesting depth is to use a LOOKUP