Limit on number of conditions?

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?

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.

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?

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