Help asked in Computers & InternetSoftware · 3 years ago

Can someone help me out with this excel problem?

In cell B8, create a formula without using a function that determines the total interest associated with the mortgage. First, multiply the value in cell B6 (the number of terms) by the value in cell B7 (the number of monthly payments) and by 12 (to convert the yearly terms to monthly terms), and then subtract the value in cell B4 (the total loan amount). I can't get past this one to finish the last two. Can someone help me, please?

1 Answer

  • Cei
    Lv 5
    3 years ago
    Favourite answer

    =(B6*B7*12) - B4

Still have questions? Get answers by asking now.