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.
This exercise is part of the course
Loan Amortization in Google Sheets
Exercise instructions
- Modify the periods in column
D
so that they show "" checking first if the prior period is blank, then if the prior closing balance is zero using anIFS()
formula. - Change the periods in column
D
from numeric values to the formulaROW()-4
as the final condition on theIFS()
formula. - Do not update any column other than column
D
.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
