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