Increase number of IF statement?

  • Thread starter Thread starter mowen
  • Start date Start date
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
 
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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple if statements 5
If statement with dates 0
Three possible outputs from an if statement. 3
IF and THEN statements 5
If statement for a range of cells 3
IF statement Help 10
Alignment for a cell during an if statement. 10
Excel JUMP FROM SEARCH BAR TO RESULT 3

Back
Top