Adjustment needed for formula

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

Bob Vance

--
=IF(DK5132<=0,"","OVERDUE")
At the moment this formula gives me an
"OVERDUE "when there is more than 0, how can I have "CREDIT" if the cell was
to show -1 or more in minus???

Thanks in advance for your help....Bob Vance
 
I like your new tagline, Ken!

Regards,

Vasant.

Ken Wright said:
My pleasure ;-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
Newsgroups - Where you really can get a free lunch!!
-------------------------------------------------------------------------- --



Bob Vance said:
Thanx :)

--



Thanks in advance for your help....Bob Vance
Ken Wright said:
=IF(DK5132<=-1,"CREDIT",IF(DK5132<=0,"","OVERDUE"))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
Click to expand...
---------------------------------------------------------------------------------------------------------------------------------------------------- cell
was
to show -1 or more in minus???

Thanks in advance for your help....Bob Vance
Click to expand...
Click to expand...
Click to expand...
 
Back
Top