IF statement??

[Peter]

Is there any way of getting around the 7 or 8 limit that the IF formula
statement sets. Any help appreciated.

Pete.

 

[Don Guillett]

Lots of ways such as lookup tables, etc. What do you want to do?

 

[Peter]

It is a sheet I have for keeping a record of variuos medications. So, when I
enter for example, Diovan in cell C1, the RX number which is for example
123456, will appear in cell D1. Trouble is, I have about 14 different
medications, and the IF statement I have been using allows only 8.. Hope
this makes sense.
Thanx.

Pete
**********

 

[Gord Dibben]

Peter

Usually there is another way to do what you want. VLOOKUP, MATCH, CHOOSE or
similar.

Perhaps if you described what you are doing you could get an alternate.

But, to answer your question. Yes, there is. See Chip Pearson's method.

http://www.cpearson.com/excel/nested.htm

Gord Dibben XL2002

 

[Gord Dibben]

Peter

VLOOKUP wil handle that.

Basic example.....

Enter your medications down column A
Enter the corresponding RX numbers down Column B

In D1 enter =VLOOKUP(C1,$A$1:$B$14,2,FALSE)

Now enter a name in C1. Result in D1 will be the RX number.

To make for less typing in C1........

Select C1 then Data>Validation>Allow>List. Select the A1:A14 Range. Check
"ignore blanks" and "in-cell dropdown" then OK your way out.

C1 will now have a dropdown list to pick the medications from.

You can hide Columns A and B if wish to.

Your ranges and columns may vary.

Gord Dibben XL2002