Thread: If statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ola2B Ola2B is offline
external usenet poster
 
Posts: 32
Default 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.