 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006How 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. 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 > 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 [quoted text clipped - 3 lines] > 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. =(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 > Can you post an example of your formula with nested IFs and point out > how you want to extend it? [quoted text clipped - 11 lines] > > 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. 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? > =(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"," ")))))))) > [quoted text clipped - 20 lines] > > > 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)  SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > 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, [quoted text clipped - 14 lines] > > > =(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"," ")))))))) > > 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 [quoted text clipped - 18 lines] > > > > 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. Thank you for the reference to lookup. I was able to research that and have made it work. I really appreciate your response. > =(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"," ")))))))) > [quoted text clipped - 20 lines] > > > 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 SignatureKind 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 [quoted text clipped - 3 lines] | 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. Niek - thank you for the link. It will prove invaluable to me in the future. > http://www.cpearson.com/excel/nested.htm > [quoted text clipped - 5 lines] > | 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.