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(G30,((I4*C4)*(1+H4)),((J4*C4)* (1+H4))))

I tried to use ISNUMBER(C4) like this:


=IF(NOT(ISNUMBER(C4)),0,IF(G30,((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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Minitman" schrieb im Newsbeitrag
...
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(G30,((I4*C4)*(1+H4)),((J4*C4)* (1+H4))))

I tried to use ISNUMBER(C4) like this:


=IF(NOT(ISNUMBER(C4)),0,IF(G30,((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

I would say the same...

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

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

--
Zur
-----------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...fo&userid=1464
View this thread: http://www.excelforum.com/showthread.php?threadid=26751

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


On Fri, 8 Oct 2004 08:06:53 +0200, "Frank Kabel"
wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Minitman" schrieb im Newsbeitrag
.. .
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(G30,((I4*C4)*(1+H4)),((J4*C4)* (1+H4))))

I tried to use ISNUMBER(C4) like this:


=IF(NOT(ISNUMBER(C4)),0,IF(G30,((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