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
|