Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If, Then formula
I am working on a formula to show 11 if, then statements on the same cell?
The problem is that I am only able to input 8 of 11 on my if-then statements? Is this a max? -- LT |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If, Then formula
On Feb 5, 1:02 pm, LT wrote:
I am working on a formula to show 11 if, then statements on the same cell? The problem is that I am only able to input 8 of 11 on my if-then statements? Is this a max? -- LT I believe the max is 7, though there are some clever workarounds using concatenated strings. However, it sounds like you need some kind of lookup table approach instead. Could you send more details of your problem? G |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If, Then formula
There's a maximum of seven nested functions in Excel versions prior to XL
2007. Some ideas on circumventing this limit: http://www.ozgrid.com/Excel/nested-function-limit.htm Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "LT" wrote: I am working on a formula to show 11 if, then statements on the same cell? The problem is that I am only able to input 8 of 11 on my if-then statements? Is this a max? -- LT |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If, Then formula
=IF(A1=J16,K16,IF(A1=J17,K17,IF(A1=J18,K18,IF(A1=J 19,K19,IF(A1=J20,K20,IF(A1=J21,K21,IF(A1=J22,K22,I F(A1=J23,K23))))))))
This is my formula.. I have 2 other ones to input. Example Apple WBT Baby WEX Car WFG -- LT " wrote: On Feb 5, 1:02 pm, LT wrote: I am working on a formula to show 11 if, then statements on the same cell? The problem is that I am only able to input 8 of 11 on my if-then statements? Is this a max? -- LT I believe the max is 7, though there are some clever workarounds using concatenated strings. However, it sounds like you need some kind of lookup table approach instead. Could you send more details of your problem? G |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If, Then formula
You may want to try =vlookup().
I'd put that table on a separate worksheet and then: =vlookup(a1,sheet2!a:b,2,false) Debra Dalgleish has some notes: http://www.contextures.com/xlFunctions02.html LT wrote: =IF(A1=J16,K16,IF(A1=J17,K17,IF(A1=J18,K18,IF(A1=J 19,K19,IF(A1=J20,K20,IF(A1=J21,K21,IF(A1=J22,K22,I F(A1=J23,K23)))))))) This is my formula.. I have 2 other ones to input. Example Apple WBT Baby WEX Car WFG -- LT " wrote: On Feb 5, 1:02 pm, LT wrote: I am working on a formula to show 11 if, then statements on the same cell? The problem is that I am only able to input 8 of 11 on my if-then statements? Is this a max? -- LT I believe the max is 7, though there are some clever workarounds using concatenated strings. However, it sounds like you need some kind of lookup table approach instead. Could you send more details of your problem? G -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If, Then formula
You could try something like this:
=LOOKUP(A1,J16:K25) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "LT" wrote in message ... =IF(A1=J16,K16,IF(A1=J17,K17,IF(A1=J18,K18,IF(A1=J 19,K19,IF(A1=J20,K20,IF(A1=J21,K21,IF(A1=J22,K22,I F(A1=J23,K23)))))))) This is my formula.. I have 2 other ones to input. Example Apple WBT Baby WEX Car WFG -- LT " wrote: On Feb 5, 1:02 pm, LT wrote: I am working on a formula to show 11 if, then statements on the same cell? The problem is that I am only able to input 8 of 11 on my if-then statements? Is this a max? -- LT I believe the max is 7, though there are some clever workarounds using concatenated strings. However, it sounds like you need some kind of lookup table approach instead. Could you send more details of your problem? G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |