If Function Limitation

S

sayk

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

Ron Coderre

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
 
S

sayk

You were right on the money,

Thanks!

Ron Coderre said:
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
Click to expand...
 
B

Bob Phillips

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