Adjustment needed for formula

[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

 

[Ken Wright]

=IF(DK5132<=-1,"CREDIT",IF(DK5132<=0,"","OVERDUE"))

 

[Bob Vance]

Thanx

 

[Ken Wright]

My pleasure ;-)

 

[Vasant Nanavati]

I like your new tagline, Ken!

Regards,

Vasant.

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!!
-------------------------------------------------------------------------- --

Thanx

--



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

=IF(DK5132<=-1,"CREDIT",IF(DK5132<=0,"","OVERDUE"))

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

---------------------------------------------------------------------------------------------------------------------------------------------------- cell
was

to show -1 or more in minus???

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

 

[Ken Wright]

LOL - It's true though!!! If you've ever seen the film 'Pay It Forward'
though, it would be nice to think the same principle applied here.

http://www.haro-online.com/movies/pay_it_forward.html