| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement
Excel refuses to accept more argument as per below. Foe example i wanted to add "if("January","December"). it would not let me further that the argument below. Can anyone please help!!!!!! =IF(I5="MAY","APRIL",IF(I5="JUNE","MAY",IF(I5="JUL Y","JUNE",IF(I5="AUGUST","JULY",IF(I5="SEPTEMBER", "AUGUST",IF(I5="OCTOBER","SEPTEMBER",IF(I5="NOVEMB ER","OCTOBER",IF(I5="DECEMBER","NOVEMBER"))))))) ) Many thanks in advance, Ola. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement
How about something like:
=TEXT(DATE(2007,MONTH(DATEVALUE(I5&"-2007"))-1,1),"MMMM") Ola2B wrote: Excel refuses to accept more argument as per below. Foe example i wanted to add "if("January","December"). it would not let me further that the argument below. Can anyone please help!!!!!! =IF(I5="MAY","APRIL",IF(I5="JUNE","MAY",IF(I5="JUL Y","JUNE",IF(I5="AUGUST","JULY",IF(I5="SEPTEMBER", "AUGUST",IF(I5="OCTOBER","SEPTEMBER",IF(I5="NOVEMB ER","OCTOBER",IF(I5="DECEMBER","NOVEMBER"))))))) ) Many thanks in advance, Ola. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement
Many thanks Dave! it now works perfectly.
Dave Peterson wrote: How about something like: =TEXT(DATE(2007,MONTH(DATEVALUE(I5&"-2007"))-1,1),"MMMM") Ola2B wrote: Excel refuses to accept more argument as per below. Foe example i wanted to add "if("January","December"). it would not let me further that the argument below. Can anyone please help!!!!!! =IF(I5="MAY","APRIL",IF(I5="JUNE","MAY",IF(I5="JUL Y","JUNE",IF(I5="AUGUST","JULY",IF(I5="SEPTEMBER", "AUGUST",IF(I5="OCTOBER","SEPTEMBER",IF(I5="NOVEMB ER","OCTOBER",IF(I5="DECEMBER","NOVEMBER"))))))) ) Many thanks in advance, Ola. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| IF Statement?? | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
