Posted to microsoft.public.excel.worksheet.functions

Sarah_Lecturer Sarah_Lecturer is offline

external usenet poster

Posts: 18

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nested IF statements	Valerie	Excel Worksheet Functions	2	February 19th 09 03:36 AM
Nested IF statements using AND / OR	Joe[_13_]	Excel Worksheet Functions	2	February 9th 09 06:14 PM
Help with nested if/or statements	Nick	Excel Discussion (Misc queries)	8	September 14th 07 03:46 PM
Nested IF statements	John Simons	Excel Worksheet Functions	14	February 16th 05 06:17 AM
Do I need nested IF statements?	Jaramya	Excel Worksheet Functions	1	November 5th 04 09:10 PM

All times are GMT +1. The time now is 07:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us