IF THEN statement error

[kolbydayne]

Whenever I enter the following formula, Excel tells me that "the formul
you typed contains an error." When I click OK, it then highlights th
last "ISNUMBER" function in the formula. What is wrong with th
formula?

=IF(ISNUMBER(G50-G49),G50-G49,IF(ISNUMBER(G50-G48),G50-G48,IF(ISNUMBER(G50-G45),G50-G45,IF(ISNUMBER(G50-G25),G50-G25,IF(ISNUMBER(G50-G24),G50-G24,IF(ISNUMBER(G50-G23),G50-G23,IF(ISNUMBER(G50-G22),G50-G22,IF(ISNUMBER(G50-G21),G50-G21,1)))))))

 

[kolbydayne]

Also, whenever I post a thread to this board, why does it send out a
email message? I received a complaint yesterday, but I do not kno
what I am doing wrong

 

[Alan]

You have eight nested 'IF's, you can only have seven. You need to look at
another function, maybe VLOOKUP,
Regards,

 

[Jonathan Rynd]

Whenever I enter the following formula, Excel tells me that "the formula
you typed contains an error." When I click OK, it then highlights the
last "ISNUMBER" function in the formula. What is wrong with the
formula?

Your formula has too many levels of depth. Excel only supports a limited
number of nested functions. You have nested functions 9 deep.

What you have to do is put the inner part of your formula into another
cell, or write the function in VBA.

 

[Jonathan Rynd]

Also, whenever I post a thread to this board, why does it send out an
email message? I received a complaint yesterday, but I do not know
what I am doing wrong!

You'd have to ask the administrators of excelforum.com that question. I
don't think they monitor this board. My hunch is that you are not doing
anything wrong, that the complainer signed up to receive email messages and
then forgot he did.

 

[Frank Kabel]

Hi
you have exceeded Excel's maximum of nexted functions (which is 8). In
your case you have used to many IF statements. What are you trying do
check with this formula. It seems you expect non numeric entries in the
cells G50, G49, G45, etc.

 

[kolbydayne]

Thanks you guys for the help.

I removed one of the if statements that was not necessary, and it work
fine now.

Frank,
What I was trying to accomplish was to have the spreadsheet pick up o
the first numeric cell it came to, going upwards from G50.