If Function Limitation

How can one have more than 7 If Functions nested, I have the need to create
more than 7 If Functions, how can I go around this problem,

I consulted the Help Section and it states:
"Up to seven IF functions can be nested as value_if_true and value_if_false
arguments"

Your help is most appreciated!

In practically every instance I run across where you need more than 7 IF
statements, the problem can be solved by constructing a Lookup table of
values to be matched and their corresponding return value.

Example:
Col_A Col_B
Apple 1
Berry 100
Cat 11
Date 21
Eel 35
Fruit 106
Grate 17
Hail 0
etc (something)

C1: Eel
D1: =VLOOKUP(C1,A1:B8,2,0)
(returns 35)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"sayk" wrote:

> How can one have more than 7 If Functions nested, I have the need to create
> more than 7 If Functions, how can I go around this problem,
>
> I consulted the Help Section and it states:
> "Up to seven IF functions can be nested as value_if_true and value_if_false
> arguments"
>
> Your help is most appreciated!
>
>
>

You were right on the money,

Thanks!

"Ron Coderre" <ronSKIPTHIScoderre@bigfoot.com> wrote in message
news:148B685E-836A-4976-90F5-AA468FD0D75F@microsoft.com...
> In practically every instance I run across where you need more than 7 IF
> statements, the problem can be solved by constructing a Lookup table of
> values to be matched and their corresponding return value.
>
> Example:
> Col_A Col_B
> Apple 1
> Berry 100
> Cat 11
> Date 21
> Eel 35
> Fruit 106
> Grate 17
> Hail 0
> etc (something)
>
> C1: Eel
> D1: =VLOOKUP(C1,A1:B8,2,0)
> (returns 35)
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "sayk" wrote:
>
>> How can one have more than 7 If Functions nested, I have the need to
>> create
>> more than 7 If Functions, how can I go around this problem,
>>
>> I consulted the Help Section and it states:
>> "Up to seven IF functions can be nested as value_if_true and
>> value_if_false
>> arguments"
>>
>> Your help is most appreciated!
>>
>>
>>

Glad that you said practically Ron. I have at least two instances of the
limitation that I got around with a named range, lookups were of no use.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sayk" <sjc_ni@hotmail.com> wrote in message
news:uOhrFBeBGHA.2320@TK2MSFTNGP11.phx.gbl...
> You were right on the money,
>
> Thanks!
>
> "Ron Coderre" <ronSKIPTHIScoderre@bigfoot.com> wrote in message
> news:148B685E-836A-4976-90F5-AA468FD0D75F@microsoft.com...
> > In practically every instance I run across where you need more than 7 IF
> > statements, the problem can be solved by constructing a Lookup table of
> > values to be matched and their corresponding return value.
> >
> > Example:
> > Col_A Col_B
> > Apple 1
> > Berry 100
> > Cat 11
> > Date 21
> > Eel 35
> > Fruit 106
> > Grate 17
> > Hail 0
> > etc (something)
> >
> > C1: Eel
> > D1: =VLOOKUP(C1,A1:B8,2,0)
> > (returns 35)
> >
> > Does that help?
> >
> > ***********
> > Regards,
> > Ron
> >
> > XL2002, WinXP-Pro
> >
> >
> > "sayk" wrote:
> >
> >> How can one have more than 7 If Functions nested, I have the need to
> >> create
> >> more than 7 If Functions, how can I go around this problem,
> >>
> >> I consulted the Help Section and it states:
> >> "Up to seven IF functions can be nested as value_if_true and
> >> value_if_false
> >> arguments"
> >>
> >> Your help is most appreciated!
> >>
> >>
> >>
>
>