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