Why is there an 'IF' statement at the end of the formula for Principal Repay in cell G38?
The 'IF' statement in the formula checks whether the value in cell G36 is equal to 0. If it is, the formula returns 0, indicating that no repayment is required. Otherwise, the formula returns the result of the VLOOKUP function, indicating the principal repayment amount.