macropod Wrote:
Hi daddylonglegs,

Not if B4 is zero. The correct rendition should have been:
=IF(OR(B5=0,B4=0),0,PMT(B3/B5,B4*B5,B6))

An alternative rendition would be:
=IF(B5*B4=0,0,PMT(B3/B5,B4*B5,B6))

Cheers



Indeed macropod, you are correct, although, based on my original
formula, you can use

=IF(B5*B4,PMT(B3/B5,B4*B5,B6),0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537573