Question

On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the

Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set

the references to cells B5 and B6 as absolute references.

Answer 1

=IF(PMT($B$5/12;10;$B$6)<0;PMT($B$5/12;10;$B$6)*-1;PMT($B$5/12;10;$B$6))