Re If statement....HELP!!!!

O

Ola2B

Excel refuses to accept more argument as per below. For example i
wanted to add "if("January","December") to the formula below but it
would not allow me to do it. Can anyone please help!!!!!!

=IF(I5="MAY","APRIL",IF(I5="JU-NE","MAY",IF(I5="JULY","JUNE",-
IF(I5="AUGUST","JULY",IF(I5="S-EPTEMBER","AUGUST",IF(I5="OCTO-
BER","SEPTEMBER",IF(I5="NOVEMB-
ER","OCTOBER",IF(I5="DECEMBER"-,"NOVEMBER")))))))).


i wouldn't mind if a macro is written to do the function.

Many thanks,
Ola.
 
D

Dave Peterson

Check your other post.
Excel refuses to accept more argument as per below. For example i
wanted to add "if("January","December") to the formula below but it
would not allow me to do it. Can anyone please help!!!!!!

=IF(I5="MAY","APRIL",IF(I5="JU-NE","MAY",IF(I5="JULY","JUNE",-
IF(I5="AUGUST","JULY",IF(I5="S-EPTEMBER","AUGUST",IF(I5="OCTO-
BER","SEPTEMBER",IF(I5="NOVEMB-
ER","OCTOBER",IF(I5="DECEMBER"-,"NOVEMBER")))))))).

i wouldn't mind if a macro is written to do the function.

Many thanks,
Ola.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a common starting point 6
Mapping strings to integers 5
Consolidate/ Clean-Up Some Code 3
Re training expiry date formula required 3
Triggering a macro after Printing 5
Search and replace problem 4
Months of review 7
Please help me with this example 4

Top