Using FILTER to create a new table without NAs
In this exercise, you will be using the FILTER()
formula to create a new table for your visualizations and schedule.
The initial table where the formulas have been completed have been moved to columns Q:Z
.
To create the new table, add the FILTER()
formula in cell F3
, referring to the initial table in Q13:Z195
.
The visualizations will still refer to the original table, but will be corrected in the next exercise.
Este exercício faz parte do curso
Loan Amortization in Google Sheets
Instruções do exercício
- Enter the
FILTER()
formula that will remove all errors from the calculated area. - For the filter condition, use the closing balance, and add a condition that it is greater than -0.01 (this is due to rounding).
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
