Extension needed to formula

[Bob Vance]

--
=IF(DL3018 >-1, "AMOUNT DUE",IF(DL3018<0,"CREDIT")).........also if DL3018 &
DL3011 are the same value "Account Overdue"


Thanks in advance for your help....Bob Vance

 

[Peo Sjoblom]

=IF(DL3018=DL3011,"Account Overdue",IF(DL3018>-1,"Amount Due","Credit"))

you might want to check for blanks as well

=IF(AND(DL3018<>"",DL3018=DL3011),"Account
Overdue",IF(AND(DL3018<>"",DL3018>-1),"Amount Due","Credit"))

 

[Bob Vance]

=IF(DL138=DL131,"ACCOUNT OVERDUE",IF(DL138>-1,"AMOUNT DUE","CREDIT"))
thanx it works good but can it be adjusted so as if DL131 reads zero
nothing shows ""?

 

[Norman Harker]

Hi Bob!

Try:

=IF(DL131=0,"",IF(DL138=DL131,"ACCOUNT OVERDUE",IF(DL138>-1,"AMOUNT
DUE","CREDIT")))

But are you happy that it should return "" if DL131 and DL138 are 0?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Vance]

BRILLIANT Thanx