To see what share of your food budget goes to delivery, divide what you spent on delivered food by your total food spend for the same month, then format the result as a percentage. If delivery was ₹3,200 and total food spend was ₹10,000, the share is 32 per cent.
The one-line formula
In a sheet, put delivery spend in cell B2 and total food spend in cell C2. Then:
- =B2/C2 gives the share as a decimal. Format the cell as a percentage to see 32%.
- =IFERROR(B2/C2,0) does the same but shows zero instead of an error when total food spend is empty.
- =ROUND(B2/C2*100,1) shows the share as a plain number with one decimal, for example 27.5.
These formulas work the same in Excel and Google Sheets. The important part is not the formula, it is deciding what goes in each cell.
What counts as the food budget?
Decide the denominator once and keep it. A common choice is everything you spend on food: groceries, eating out, delivery, and tea and snacks outside. Then delivery is one slice of the whole. A narrower choice is only prepared food, meaning restaurants plus delivery, which makes the delivery share look larger. Neither is wrong, but mixing them from month to month makes the trend meaningless.
Also decide where delivery fees and tips go. Putting them with the delivery spend, as part of what you paid, shows the true cost of ordering.
A made-up example over three months
Say the food budget total and delivery spend look like this. All numbers are invented.
| Month | Delivery spend | Total food spend | Delivery share |
|---|---|---|---|
| Month 1 | ₹3,200 | ₹10,000 | 32% |
| Month 2 | ₹2,800 | ₹10,200 | 27.5% |
| Month 3 | ₹2,400 | ₹9,600 | 25% |
Month 2 is 2,800 divided by 10,200, which is 0.2745, or about 27.5 per cent. Month 3 is 2,400 divided by 9,600, exactly 25 per cent. Delivery fell by ₹800 over the two months, and the share dropped seven points, from 32 to 25.
Is a falling share always good news?
Not always. A share is a ratio, so it can fall because delivery fell or because the total rose. In month 2 above, total food spend went up by ₹200, which accounts for a small part of the drop. Always look at the rupee figures next to the percentage. If delivery stays at ₹3,200 and the total rises to ₹12,000, the share falls to about 27 per cent while you have actually changed nothing.
How to collect the two figures
- Tag every food payment as one of three lines: groceries, eating out and delivery.
- At the end of the month, add up the delivery line.
- Add up all three lines for the total.
- Enter both in the sheet and let the formula compute the share.
If you import bank and card statements into SpendixAI, you can create categories for these lines and let a rule or its learned history tag the merchants for you. Reports and the Report builder show totals by category, so the two figures are quick to find. Review the imported rows before saving and fix any food-app payment that landed in the wrong line.
A quick sanity check
Before you trust the percentage, add the three food lines yourself once and compare the result with the total in your sheet. A missed payment or a doubled one will shift the share by a point or two. Spend two minutes checking a single month and the later months will be easier to believe.
What to do with the result
Pick a target share that feels realistic, say five points lower than now, and check it each month. Or ignore the percentage and set a rupee ceiling for delivery as covered in a weekly budget. The share is most useful as a trend line: three months show you a direction, one month shows you very little.
If you want more detail, split the delivery line into restaurant orders and quick-commerce apps. They behave differently, and the formula applies to each.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
