Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you use more than 7 arguments in a logical IF?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you use more than 7 arguments in a logical IF?
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 Bill wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you use more than 7 arguments in a logical IF?
=(IF(K14=60210,"OF1130",IF(K14=60415,"OE1480",IF(K 14=60511,"OR1600",IF(K14=61211,"MF2000",IF(K14=612 40,"MF2040",IF(K14=61414,"ME2280",IF(K14=61511,"MR 2380"," "))))))))
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 "Pete_UK" wrote: 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 Bill wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you use more than 7 arguments in a logical IF?
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? "Bill" wrote: =(IF(K14=60210,"OF1130",IF(K14=60415,"OE1480",IF(K 14=60511,"OR1600",IF(K14=61211,"MF2000",IF(K14=612 40,"MF2040",IF(K14=61414,"ME2280",IF(K14=61511,"MR 2380"," ")))))))) 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 "Pete_UK" wrote: 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 Bill wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you use more than 7 arguments in a logical IF?
http://www.cpearson.com/excel/nested.htm
-- Kind regards, Niek Otten Microsoft MVP - Excel "Bill" wrote in message ... |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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you use more than 7 arguments in a logical IF?
=VLOOKUP(K14,Sheet2!A1:B20,2,False)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Bill" wrote in message ... 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? "Bill" wrote: =(IF(K14=60210,"OF1130",IF(K14=60415,"OE1480",IF(K 14=60511,"OR1600",IF(K14=6 1211,"MF2000",IF(K14=61240,"MF2040",IF(K14=61414," ME2280",IF(K14=61511,"MR23 80"," ")))))))) 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 "Pete_UK" wrote: 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 Bill wrote: 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you use more than 7 arguments in a logical IF?
Thank you for the reference to lookup. I was able to research that and have
made it work. I really appreciate your response. "Bill" wrote: =(IF(K14=60210,"OF1130",IF(K14=60415,"OE1480",IF(K 14=60511,"OR1600",IF(K14=61211,"MF2000",IF(K14=612 40,"MF2040",IF(K14=61414,"ME2280",IF(K14=61511,"MR 2380"," ")))))))) 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 "Pete_UK" wrote: 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 Bill wrote: 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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you use more than 7 arguments in a logical IF?
Niek - thank you for the link. It will prove invaluable to me in the future.
"Niek Otten" wrote: http://www.cpearson.com/excel/nested.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Bill" wrote in message ... |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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulae containing more than 7 arguments? | Excel Worksheet Functions | |||
Formulas that refer to (several) other columns for arguments... | Excel Worksheet Functions | |||
Arguments box on form | Excel Discussion (Misc queries) | |||
conditional sum - number of arguments problem | Excel Worksheet Functions | |||
Is it possible to nest more than 7 arguments in one function? | Excel Discussion (Misc queries) |