IF Statemmtns

[Omer]

Hi,

How may IF statements can you have embedded within each
other?

If the limit is 7 or 8, Is there are way around it?

Thanks
omer

 

[Bill]

I believe the limit is 7. I have used the VLOOKUP function as a way around
IF statement limitations.

Bill Foley
www.pttinc.com

 

[Don Guillett]

Limit 7, You can use LOOKUP functions or CHOOSE, etc.
or, if you insist you can use + between ifs

 

[Guest]

There is a way around that. You can set a VLookup. What
you need to do is setup a master list. ie. If you have a
list of ten items that you want to coordinate a number
with you need to input the name of the items in the first
cell and in the cell beside it assign a number to it.

Column A Column B
Red 1
Blue 2
Yellow 3
Purple 4
etc . . .

Then you need to assign the following formula.

=VLOOKUP(B22,$A$2:$B$13,2,FALSE)

B22 is the cell that you want the result in.

$A$2:$B$13, would be all of your data in columns A & B

2 means that you want whatever is in column B to be
displayed in B22 whenever the related color in typed. Ie.
when you type Red in a cell, then 1 will be displayed
cell B22.

 

[biff]

Just a slight correction:

=VLOOKUP(B22,$A$2:$B$13,2,FALSE)

B22 is the cell that you want the result in.

B22 is the Lookup_Value - the value to search for in the
Lookup_Array (A2:B13).

2 means that you want whatever is in column B to be
displayed in B22 whenever the related color in typed. Ie.
when you type Red in a cell, then 1 will be displayed
cell B22.

It would be displayed in whatever cell holds the formula.
Using your formula entered in cell B22 would lead to a
circular reference.

Biff