Limit on number of conditions?

A

Amy F.

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?
 
J

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
 
L

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
 
A

Amy F.

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