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

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

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

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

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

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