Multiple IF statements

Stewart Jackson

Board Regular
Joined
Apr 18, 2005
Messages
51
Hi everyone..

Is it possible to write a string which has 12 possibilities....?

eg =If (a1 = "July",1,If(a1="August",2,if ....... and so until u get to June.

Normally the limit is 7 "if" statements and Excel wont allow anymore..

Can anyone offer a solution or alternative..
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

tactps

Well-known Member
Joined
Jan 20, 2004
Messages
3,459
There are many alternatives.

Make July a date, formatted as "mmmm".

Then use this fomula:
=IF(MONTH(A7)>6,MONTH(A7)-6,MONTH(A7)+6)
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
You could use this formula if you have text in A1

=MATCH(A1,{"july","august","september","october","november","december","january","february","march","april","may","june"},0)

...or, following tactps' suggestion with a date in A1

=MOD(MONTH(A1)+5,12)+1
 

Watch MrExcel Video

Forum statistics

Threads
1,119,137
Messages
5,576,300
Members
412,716
Latest member
thviid
Top