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