Hiding unused values using IFS

Another way to hide values that you are not using is to use an IFS() formula to check if there are any further balances which need to be shown.

There are 2 cases where you would want to hide a row:

• The previous row is blank; it two or more periods after the final amortization period.
• The previous row had a closing balance of zero; that is that the row immediately after the final amortization period.

When you check if the prior row is blank, check the value in column G. When you check against the previous closing balance, make sure to check if the balance is less than 0.01!