How Do You Get ISNUMBER() To Work?

[Minitman]

Greetings,

I am trying to change this cell formula to return a "0" with any
value in C4 that is not a number (this works for "Loan", but I have
found other entries in that column that it wont work with):

=IF(C4="Loan",0,IF(G3>0,((I4*C4)*(1+H4)),((J4*C4)*(1+H4))))

I tried to use ISNUMBER(C4) like this:


=IF(NOT(ISNUMBER(C4)),0,IF(G3>0,((I4*C4)*(1+H4)),((J4*C4)*(1+H4))))

It only returns "0" regardless of what is in C4.

Any idea as to what I did wrong? Any suggestions would be most
appreciated.

TIA

-Minitman

 

[Frank Kabel]

Hi
any chance C4 is fomrated as 'Text'?. And also for what entries did you
receive '0' as a result

 

[Zurn]

I would say the same...

Also, why use the NOT(ISNUMBER(D4))

Use the IF(ISNUMBER(), here formula, 0) it is the sam

 

[Minitman]

Hey Frank,

Column C is set to "Number".

This is strange! Last night I lost my most recent changes to this
spreadsheet when my OS did a core dump and rebooted. At that point I
called it a night!. This morning when I got this reply, I tried to
recreate the conditions that caused the problem. Now this formula is
working. This is embarrassing!

I would have assumed it was still broken if you hadn't sent your reply
and I tried to duplicate the problem to answer your question. Your
reply was indeed helpful, just not the way either one of us thought it
would be - Thank you.

-Minitman