ExcelBanter - Principal & Interest Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Principal & Interest Formula (https://www.excelbanter.com/excel-worksheet-functions/264425-principal-interest-formula.html)

Scoober

Principal & Interest Formula

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

Niek Otten

Principal & Interest Formula

=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

All times are GMT +1. The time now is 02:56 PM.