IF Statemmtns

  • Thread starter Thread starter Omer
  • Start date Start date
O

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
 
Limit 7, You can use LOOKUP functions or CHOOSE, etc.
or, if you insist you can use + between ifs
 
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.
 
Just a slight correction:
=VLOOKUP(B22,$A$2:$B$13,2,FALSE)

B22 is the cell that you want the result in.
Click to expand...

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.
Click to expand...

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

Biff
 
Back
Top