If you want to know how to get around the limit of 7 nested IF
statements, you might find some useful information at this link to Chip
Pearson's site:

http://www.cpearson.com/excel/nested.htm

Hope this helps.

Pete