If Formula Nesting Level Error

[mcam22]

I am trying to use the following formula in Excel 2007, but I keep getting the following error message: "The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format"

Can anyone help? This is the formula I am trying to use:


=IF(F2="January","April",IF(F2="February","May",IF(F2="March","June",IF(F2="April","July",IF(F2="May","August",IF(F2="June","September",IF(F2="July","October",IF(F2="August","November",IF(F2="September","December",IF(F2="October","January",IF(F2="November","February",IF(F2="December","March",""))))))))))))</SPAN>

 

[Ron Coderre]

with
F2: a month name....February

This regular formula returns the name of the month that is 3 months after that month:

G2: =TEXT(EDATE(F2&1,3),"mmmm")

In that example, the formula returns: May

Is that something you can work with?

 

[Brian from Maui]

Have you tried using VLOOKUP instead of those nested IF functions?