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.

post what you have so far.
--
Gary's Student


"sc" wrote:

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
--
Allllen


"sc" wrote:

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(P65.99,".640",IF(P65.74,".625",IF(P65.49,". 610",IF(P65.24,".596",IF(P64.99,".582",IF(P64.7 4,".567",IF(P64.24,".540",IF(P63.99,".526")))))) ))

"Gary''s Student" wrote:

post what you have so far.
--
Gary's Student


"sc" wrote:

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 LOOKUP would probably be better.
--
David Biddulph

"sc" wrote in message
...
=IF(P65.99,".640",IF(P65.74,".625",IF(P65.49,". 610",IF(P65.24,".596",IF(P64.99,".582",IF(P64.7 4,".567",IF(P64.24,".540",IF(P63.99,".526")))))) ))

"Gary''s Student" wrote:

post what you have so far.
--
Gary's Student


"sc" wrote:

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.

"Tip #10

Too many Nested IF's

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

From http://excelchampion.com/tips.htm


--
ExcelChampion
------------------------------------------------------------------------
ExcelChampion's Profile: http://www.officehelp.in/member.php?userid=5096
View this thread: http://www.officehelp.in/showthread.php?t=1261683

Posted from - http://www.officehelp.in