ExcelBanter - Re If statement....HELP!!!!

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Re If statement....HELP!!!! (https://www.excelbanter.com/excel-programming/401155-re-if-statement-help.html)

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

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.

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

Check your other post.

Ola2B wrote:

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.

--

Dave Peterson