I still get an answer of #NUM! Let me try again:
1) Original formula works for computing loan interest:
=-CUMIPMT(H35/12,H37*12,H34,1,12,0)
2) But when H35 (interest rate) is a value of 0 I get #NUM!

--
lena


"Rick Rothstein (MVP - VB)" wrote:

Use the MAX function. Assuming your posted formula is the one you want to
use...

=MAX(0,-CUMIPMT(H13/12,H14*12,H12,1,12,0))

Rick


"lena" wrote in message
...
I'm doing mortgage calculations such as
=-CUMIPMT(H13/12,H14*12,H12,1,12,0)and can't figure out how to have a
result
that, when the result is a negative number, zero is entered by default.