Hiding unused rows review

After adding in the lump sum, some of the rows are no longer needed, since the loan fully amortizes 4 months ahead of schedule. Earlier in the course, you used the IFS() function to hide rows that are not needed when the loan is fully amortized.

In this lesson, you will only need to update the period column; the rest of the columns have already been updated for you. You will need to use an IFS() formula to check if the prior row is blank or the prior closing balance is zero. Use 1=1 as the non-blank condition in your IFS() formula.

Use a ROW()-4 function to calculate the period; this will allow you to copy the formula down instead of having to re-enter for all the rows.