IF function

S

sc

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.
 
A

Allllen

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
 
S

sc

=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"))))))))
 
E

ExcelChampion

"Tip #10

Too many Nested IF's

Something that goes unnoticed when trying to figure out how to fit mor
than seven IF statements into one formula is that most of the time yo
can use VLOOKUP or some other LOOKUP formula instead. VLOOKUP ca
LOOKUP exact matches or LOOKUP values in a range as in greater than 1
but less than 20. See if it will work for you."

From http://excelchampion.com/tips.ht
 
Top