Pages tagged “budget”

4 pages in Cellwise.

1. Budget vs actual: difference, over/under flag and no divide-by-zero

   Three formulas to see whether you are over budget, with a safe percent that handles a zero budget.

   budget finance

2. Budget vs actual: variance, percent and an Over/OK flag

   Variance in money and percent, an Over/OK flag, and a total, with no divide-by-zero error.

   budget finance conditional-formatting

3. How to calculate a monthly loan payment in Excel and Google Sheets (PMT)

   Work out a monthly loan payment and the total interest with PMT. Tested on sample data.

   loan PMT finance budget

4. Running balance formula for income and expenses

   A running total down a column: income so far minus spending so far.

   budget dashboard balance

All pages