How do you use more than 7 arguments in a logical IF?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am able to utilize a logical IF to automatically select the data I want to
show in a cell based on the result of the logical IF statement. My problem
is that I want to exceed the apparent limit of 7 nested IF's. The result
must show up in a speciofic cell.
I could utilize several cells (on a different worksheet) to all reference
the data in a specific cell and then use a seperate cell to query the result
of the cells but that is where I get confused.
 
Can you post an example of your formula with nested IFs and point out
how you want to extend it?

Often a lookup table can reduce a multiple-IF formula, but it depends
on exactly what you want to do.

Pete
 
Can you post an example of your formula with nested IFs and point out
how you want to extend it?

Often a lookup table can reduce a multiple-IF formula, but it depends
on exactly what you want to do.

Pete
 
=(IF(K14=60210,"OF1130",IF(K14=60415,"OE1480",IF(K14=60511,"OR1600",IF(K14=61211,"MF2000",IF(K14=61240,"MF2040",IF(K14=61414,"ME2280",IF(K14=61511,"MR2380"," "))))))))

I have 10 items in cell K14. I want to be able to extend the logic to 10
but Excel has a limit of 7 nested if's. I am not familiar with lookup tables
but will look into that.
Thank you

Bill
 
=(IF(K14=60210,"OF1130",IF(K14=60415,"OE1480",IF(K14=60511,"OR1600",IF(K14=61211,"MF2000",IF(K14=61240,"MF2040",IF(K14=61414,"ME2280",IF(K14=61511,"MR2380"," "))))))))

I have 10 items in cell K14. I want to be able to extend the logic to 10
but Excel has a limit of 7 nested if's. I am not familiar with lookup tables
but will look into that.
Thank you

Bill
 
I do have a drop down list on a different worksheet that contains all the
data available for cell K14. Can I simply take the value input in cell K14,
then use that value to select the coresponding data from the second column:
60210 OR1600
60242 OF1210
60260 OF1230
60415 OF1130
60511 OE1480
61211 MR2380
61240 MF2040
61414 MF2000
61511 MR2380
MIOEX ALLOEX
ie Cell K14 value is selected from a drop down containing the entire set of
values in the left column above. The data is on a seperate worksheet. If
cell K14 contains 61414 can I use the lookup function to select MF2000?
 
I do have a drop down list on a different worksheet that contains all the
data available for cell K14. Can I simply take the value input in cell K14,
then use that value to select the coresponding data from the second column:
60210 OR1600
60242 OF1210
60260 OF1230
60415 OF1130
60511 OE1480
61211 MR2380
61240 MF2040
61414 MF2000
61511 MR2380
MIOEX ALLOEX
ie Cell K14 value is selected from a drop down containing the entire set of
values in the left column above. The data is on a seperate worksheet. If
cell K14 contains 61414 can I use the lookup function to select MF2000?
 
http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am able to utilize a logical IF to automatically select the data I want to
| show in a cell based on the result of the logical IF statement. My problem
| is that I want to exceed the apparent limit of 7 nested IF's. The result
| must show up in a speciofic cell.
| I could utilize several cells (on a different worksheet) to all reference
| the data in a specific cell and then use a seperate cell to query the result
| of the cells but that is where I get confused.
 
http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am able to utilize a logical IF to automatically select the data I want to
| show in a cell based on the result of the logical IF statement. My problem
| is that I want to exceed the apparent limit of 7 nested IF's. The result
| must show up in a speciofic cell.
| I could utilize several cells (on a different worksheet) to all reference
| the data in a specific cell and then use a seperate cell to query the result
| of the cells but that is where I get confused.
 
=VLOOKUP(K14,Sheet2!A1:B20,2,False)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Bill said:
I do have a drop down list on a different worksheet that contains all the
data available for cell K14. Can I simply take the value input in cell K14,
then use that value to select the coresponding data from the second column:
60210 OR1600
60242 OF1210
60260 OF1230
60415 OF1130
60511 OE1480
61211 MR2380
61240 MF2040
61414 MF2000
61511 MR2380
MIOEX ALLOEX
ie Cell K14 value is selected from a drop down containing the entire set of
values in the left column above. The data is on a seperate worksheet. If
cell K14 contains 61414 can I use the lookup function to select MF2000?
Click to expand...
=(IF(K14=60210,"OF1130",IF(K14=60415,"OE1480",IF(K14=60511,"OR1600",IF(K14=6
1211,"MF2000",IF(K14=61240,"MF2040",IF(K14=61414,"ME2280",IF(K14=61511,"MR23
80"," "))))))))
 
=VLOOKUP(K14,Sheet2!A1:B20,2,False)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Bill said:
I do have a drop down list on a different worksheet that contains all the
data available for cell K14. Can I simply take the value input in cell K14,
then use that value to select the coresponding data from the second column:
60210 OR1600
60242 OF1210
60260 OF1230
60415 OF1130
60511 OE1480
61211 MR2380
61240 MF2040
61414 MF2000
61511 MR2380
MIOEX ALLOEX
ie Cell K14 value is selected from a drop down containing the entire set of
values in the left column above. The data is on a seperate worksheet. If
cell K14 contains 61414 can I use the lookup function to select MF2000?
Click to expand...
=(IF(K14=60210,"OF1130",IF(K14=60415,"OE1480",IF(K14=60511,"OR1600",IF(K14=6
1211,"MF2000",IF(K14=61240,"MF2040",IF(K14=61414,"ME2280",IF(K14=61511,"MR23
80"," "))))))))
 
Thank you for the reference to lookup. I was able to research that and have
made it work. I really appreciate your response.
 
Thank you for the reference to lookup. I was able to research that and have
made it work. I really appreciate your response.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple arguments 1
IF/OR Logic Function 7
How to use the IF function to resolved more than one creteria 4
Logical test in IF statement returning incorrect result 3
Return result of IF logical test in a different cell 1
Nested IF statements using AND / OR 2
If Statement with Two Different Logical Test 16
Logical Test 2

Back
Top