hard to tell what might work, since you don't give much description.

Conditionals with more than a few conditions can nearly always be
simplified (and made easier to maintain!) using either calculations or
lookups.

OTOH, you may be able to use the technique he

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



In article ,
Amy F. <Amy wrote:

Using Excel 2002, I'm looking for help with creating an if, then formula. I
have 10 conditions to check but it appears that formula won't allow me to
enter more than 7. Any suggestions?