IF function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to enter an IF function that has several arguments in the
formula. I can get it to return a value up to a certain point (8 arguments),
but after that, I get an error. I am by no means an expert in excel, but
can't seem to figure out why this is happening.

Any help as to why this is happening and how to fix it would be appreciated.
 
If you are doing it like this:
=IF(test1,val1,IF(test2,val2,IF(test3,val3 ... etc
then it is because you can only have 7 nested ifs

To get around this, I suggest combining 2 columns. On the seventh test in
the first column, don't put a second option. ...IF(test7,val7)))))))

The cell will return FALSE if none of the first 7 conditions were met.
Then you can have a new column saying
=IF(A1<>FALSE,A1,IF(test8,val8,IF(test9,val9 ... etc etc etc
 
=IF(P6>5.99,".640",IF(P6>5.74,".625",IF(P6>5.49,".610",IF(P6>5.24,".596",IF(P6>4.99,".582",IF(P6>4.74,".567",IF(P6>4.24,".540",IF(P6>3.99,".526"))))))))
 
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

IF function says too many nested 1
Match function: error due to format? 4
XNPV Function 1
IF AND Nested Functions - Formula Not Working 0
Problem with Yield() function 5
Formula for function/argument "exclude". 0
If argument 1
Excel VBA 1

Back
Top