ComeçarComece de graça

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

Ver curso

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

Começar o exercício