Limit on number of conditions?

[Guest]

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?

 

[JE McGimpsey]

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 here:

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

 

[Lilliabeth]

7 is the max. You haven't really given enough info, but often peopl
use nested IFs when VLookup would work better, so look in Help for tha
function

 

[Guest]

Thanks to you both - I was asking for someone else, so sorry for the limited
info. You answered it, though!