Herbert, you're right.

Excel 2007 does increase the nesting limit to 64 levels but that won't help
in this situation.

For older versions of Excel you can also concatenate the IF statements see
solution (this link is legit and does not require you to join)
http://www.eggheadcafe.com/software/...ments--ma.aspx

Here is another great workaround as well:
http://www.cpearson.com/excel/nested.htm


--
Thank you,

scrowley(AT)littleonline.com


"Herbert Seidenberg" wrote:

You can't have 130 IFs in a formula.
Maximum is 7.
To get you going, try this data entry method
without formulas or typing:
http://www.savefile.com/files/1923025