Limit on number of conditions?

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

[Lilliabeth]

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

[Amy F.]

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

"Lilliabeth" wrote:

>
> 7 is the max. You haven't really given enough info, but often people
> use nested IFs when VLookup would work better, so look in Help for that
> function.
>
>
> --
> Lilliabeth
> ------------------------------------------------------------------------
> Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
> View this thread: http://www.excelforum.com/showthread...hreadid=475068
>
>

[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



In article <E6FBA2C0-A8D0-489D-846E-20E4392F7582@microsoft.com>,
Amy F. <Amy F.@discussions.microsoft.com> 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?