Need Help Fast!

[alexm999]

In cell E13, I have the following formula:
=IF(D13="PAID",-ABS(B13),IF(D13="MO",ABS(B13+C13),IF(D13="MOC",-ABS(B13),IF(D13="SEND",ABS(B13+C13),IF(D13="DEPOSIT",-ABS(B13),IF(D13="DMO",-ABS(B13),IF(D13="CTD",-ABS(B13),IF(D13="CFD",(B13),""))))))))

In cell F13, i have the followng formula:
=F12+E13

If I have the code "DMO" in cell D13, I DO NOT want cell F13 to sum a
in the above formula. I'd like it to do nothing... How can I do that

 

[jeff]

HI,

in f13

=if(D13<>"DMO,F12+F13,"") ?

jeff

 

[Andy B]

Hi

If I understand you correctly, try this in F13:
=IF(D13="DMO",0,F12+E13)