Question: 6. In cell K4, create a formula using the IF function to calculate the interest paid on the mortgage (or the difference between the total

 6. In cell K4, create a formula using the IF function

to calculate the interest paid on the mortgage (or the difference between

6. In cell K4, create a formula using the IF function to calculate the interest paid on the mortgage (or the difference between the total payments made each year and the total amount of mortgage principal paid each year) a. The formula should first check if the value in cell H4 (the balance remaining on the loan each year) is greater than o b. If the value in cell H4 is greater than 0, the formula should return the value in J4 subtracted from the value in cell DS multiplied by 12. Use a relative cell reference to cell J4 and an absolute cell reference to cell DS. (Hint: Use 12*$D$5-J4 as the is_true argument value in the formula.) If the value in cell H4 is not greater than 0, the formula should return a value of 0. c

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!