Hi,

Take a look at solution provided by Chip to exceed the limit of 7 nested Ifs

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

HTH
Carim