Extension needed to formula

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

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
 
=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"))
 
=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 ""?
 
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.
 
Back
Top