Fixing the payment function

So far in this chapter, you have not had to adjust the payment function. In this lesson, you will need to modify the payment for all periods (except 0 and 1) so that it can accurately limit the payment to not overpay on the final installment.

To achieve this, you will use an IFS function for 3 separate conditions:

• If the period is blank, the payment should be blank.
• If the opening balance in column F is less than or equal to the adjusted payment B24 plus the interest for the period, use the opening balance plus interest.
• In all other cases, use the PMT() function.