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.
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.