Google Sheets has no Data Table command, but you can get the same result by writing the model's formula directly into a grid, so that each cell calculates its own answer from the input values on its row and column. An ARRAYFORMULA can fill a whole column or grid from a single formula. For Goal Seek, you can rearrange the formula by hand or install an add-on.
How do I do a one-variable what-if?
Use invented figures. Income is in B1 (₹70,000), fixed costs in B2 (₹38,000) and flexible costs in B3 (₹24,000). Savings with a cut to flexible spending is income minus fixed minus flexible times one minus the cut. Down A6:A9 put the cuts 0%, 10%, 20% and 30%. In B6 type:
- =$B$1-$B$2-$B$3*(1-A6)
Copy it down. You get 8,000; 10,400; 12,800 and 15,200. Or fill all four at once from B6 with =ARRAYFORMULA($B$1-$B$2-$B$3*(1-A6:A9)). The model is written out in the formula, which is the main difference from Excel: nothing swaps the input cell for you.
How do I do a two-variable grid?
Put three incomes across B5:D5: 60,000; 70,000 and 80,000, and the cuts down A6:A9. In B6 enter =B$5-$B$2-$B$3*(1-$A6) and copy across and down. The dollar signs keep each reference pointing at its own row or column heading.
| Cut | Income 60,000 (₹) | Income 70,000 (₹) | Income 80,000 (₹) |
|---|---|---|---|
| 0% | -2,000 | 8,000 | 18,000 |
| 10% | 400 | 10,400 | 20,400 |
| 20% | 2,800 | 12,800 | 22,800 |
| 30% | 5,200 | 15,200 | 25,200 |
Check one cell: income 60,000, no cut. 60,000 minus 38,000 minus 24,000 is minus 2,000, a shortfall. With a 30 percent cut, the flexible costs fall by 7,200, to ₹5,200 of savings. You can also fill the grid in one go with =ARRAYFORMULA(B5:D5-$B$2-$B$3*(1-A6:A9)). Compare one cell with your hand calculation before trusting a formula that fills many.
How do I switch between scenarios?
A dropdown does the job of Excel's Scenario Manager. Make a table with Lean, Base and Stretch columns, add a dropdown with Data, Data validation, Dropdown, and use =INDEX(B2:D2,MATCH($G$1,$B$1:$D$1,0)) to pull the chosen column into a live column. Every other formula reads the live column.
What about Goal Seek?
- By hand: if savings equal income minus fixed minus flexible, then the flexible figure for a target is income minus fixed minus the target. This takes one cell.
- By add-on: the Google Workspace Marketplace offers third-party Goal Seek add-ons. Read what permissions an add-on asks for, check who publishes it, and avoid installing one for a sheet that holds sensitive data.
- By trial: type a guess in the input cell and adjust until the result is right. Slow, but it needs nothing.
What goes wrong?
- Plain text numbers such as "10%" typed with a space or a stray symbol. Check the cell is a number.
- References that slide when copied. If results look shifted, check the dollar signs.
- ARRAYFORMULA blocked by a value in a cell it wants to fill. Clear the cells below the formula.
When does Sheets fall short?
If you want the Data Table's convenience for a long, complicated model, Excel has it and Sheets does not. For household budgets the direct-formula grid is enough, and has the advantage that every cell shows its formula, so someone reading the sheet can follow it.
If formulas start to look cluttered, name your inputs with Data, Named ranges, for example income, fixed and flexible, so a formula reads =income-fixed-flexible*(1-cut). It takes a minute to set up and makes the sheet far easier to check months later.
If the figures feeding your model come from months of statements, SpendixAI can import those and report spending by category, so your inputs are real totals rather than recollections.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

