how to use more than 8 nested if in Excel2003

June 5, 2009 at 00:40:29
Specs: Windows 2000
What i am trying to get is.
=if(a1="Jan",1,if(a1="Feb",2....if(a1=Nov",11,12)
But it doesn't allow more than 8 IFs.

See More: how to use more than 8 nested if in Excel2003

Report •


#1
June 5, 2009 at 03:52:24

Report •
Related Solutions


Ask Question