Increase number of IF statement?

M

mowen

Hi
I have a set of 24 cells that I want to check with IF statement
instead of divided the result in 4 cells as a temporar
location(because excel only allow 7 IF statement for every cell),
want to get the result in one cell without any temp cells?

Run
 
L

Leo Heuser

Hi Rune

One way:

=((A2=2)*7+(A2=3)*12+(A2=4)*34..........)

Matching: IF(A2=2,7,IF(A2=3,12,IF(A2=4,34..........)

If you tell us more about, what you're trying to
accomplish, there may be a simpler solution.
 
F

Frank Kabel

Hi
maybe you could explain the logic of your check a little
bit more.There's no way around the max. of 7 nested
function but there may be better solutions (e.g. using a
lookup table and VLOOKUP)
 
Top