5 Easy Google Sheets Functions (and how I use them

These are some of the functions I use on my Debt Payoff Dashboard!!

🧮 1. IF ()

(If the amount cell is not empty, the Dashboard will automatically add the currency symbol without me having to enter it manually)

🧨 2. IFERROR ()

(You can this function for any error handling but in this case, I use it to output “No Loan” if the progress cannot be made due to no loan existing)

⭐️3. QUERY ()

(I’m using this to find all the payments for that year and adding it all together)

➕4. SUM ()

(Adding together all payments made to get the total paid across all 4 loans)

📅 5. EDATE ()

(I use to calculate estimated payoff date based on loan start and term length)

#budgettemplate #personalgrowth #debtfreejourney #lifestyle2023 #lifemotivation #motivation2023 #personalfinance #healthylifestyle2023 #dayinmylife #digitalplanner