=IF(E20="","",PMT(H20,30,-E20))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Scoober" wrote in message
...
Hi all,

I am trying to complete a principal & interest formula that remain empty
in
the target cell if no loan amount is entered,

=IF(E20="","")*PMT(H20,30,-E20)

E20 = Loan amount
H20 = Interest Rate
L45 = Target cell

With the above cell i get Value as an answer.

Can anyone help me out with completing this formula?
--
Thanks in advance.

Scoober