View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah_Lecturer Sarah_Lecturer is offline
external usenet poster
 
Posts: 18
Default Nested If Statements

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