Help With If!!!

[alexm999]

Here is my IF Statement:

=IF(D14="PAID",-ABS(B14),IF(D14="MO",ABS(B14+C14),IF(D14="MOC",-ABS(B14),IF(D14="SEND",ABS(B14+C14),IF(D14="DEPOSIT",-ABS(B14),IF(D14="DMO",-ABS(B14),IF(D14="CTD",-ABS(B14),IF(D14="CFD",(B14),""))))))))

I want to add "MOR" but it wont let me, i get an error.

Here's what I want to add:

=IF(D14="PAID",-ABS(B14),IF(D14="MO",ABS(B14+C14),IF(D14="MOC",-ABS(B14),IF(D14="SEND",ABS(B14+C14),IF(D14="DEPOSIT",-ABS(B14),IF(D14="MOR",-ABS(B14),IF(D14="DMO",-ABS(B14),IF(D14="CTD",-ABS(B14),IF(D14="CFD",(B14),"")))))))))

iTS giving me an error...

hel

 

[Guest]

It appears that you have too many nested ifs. According to the documentation in my version of Excel it says you can have up to 7 -- although I did get 8 that seemed okay. You have 9.

Perhaps you could try using an OR in there. For example:

=IF(OR(D14="Paid",D14="MOC",D14="DEPOSIT",D14="MOR",D14="DMO",D14="CTD"),-ABS(B14),IF(OR(D14="MO",D14="SEND"),ABS(B14+C14),IF(D14="CFD",B14,"")))

Art

 

[SidBord]

What kind of error? What does it say? You may have
exceeded the max length for a formula.