Thread: USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY)
Either change to excel 2007, or use
=UPPER(TEXT(DATE(1900,Date!D2,1),"mmm"))&"."
--
David Biddulph

"Tina" wrote in message
...
I Have the following if statement in my excel spreadhseet. the only
problem
is that I cannot finish out the year with Sept.-Dec. (I get an error that
says the statement is too big) What can I do to make this formula work for
the whole year??

=IF(Date!D2=1,"JAN.",IF(Date!D2=2,"FEB.",IF(Date!D 2=3,"MAR.",IF(Date!D2=4,"APR.",
IF(Date!D2=5,"MAY",IF(Date!D2=6,"JUN.",IF(Date!D2= 7,"JUL.",IF(Date!D2=8,"AUG."))))))))


Reply With QuoteReply With Quote