Hi,

There is some problem in the logic. Since any number is =0 or <0, the
result will always toggle between "Current" and "Overdue". What exactly are
you trying to do?

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sarah_Lecturer" wrote in message
...
Hi

I am trying to create the following formulae

=IF(G7=0,"Current",IF(G7<0,"Overdue",IF(G7=-3,"Reminder","Available")))

Unfortunately G7 contains an if statement already based on other cells so
my
answer is incorrect

Can anyone give me any advice as to what to do next please? PULLING MY
HAIR
OUT!!!

Thanks

Sarah

Using MS Office Excel 2003, Sp2, Windows XP - Thanks again