How To Work Out A Percentage Of Two Numbers

The Basic Method Comes First

To work out a percentage of two numbers, you divide one number by the other, then multiply the result by 100. That is it. The formula is (Part / Whole) × 100 = Percentage. Put the smaller number or the value you are comparing on top, the total or reference number on the bottom, hit calculate, and multiply by 100. I have seen people mess this up constantly in finance spreadsheets and inventory reports, usually because they flip the denominator and numerator and end up with a percentage over 100 when it should be under 50. Here is the straightforward breakdown. Say you spent $45 out of a $180 budget. You want to know what percentage that is. Divide 45 by 180. That gives you 0.25. Multiply by 100 and you get 25%. The budget is 25% spent. Done. Now here is the part most guides skip. What if the "part" is larger than the "whole"? That happens all the time. A marketing campaign cost $12,000 against a budget of $8,000. $12,000 divided by $8,000 is 1.5, times 100 is 150%. You went 150% of budget. It is not a mistake. The math is correct. The result just tells you you overspent by 50%, which is different from saying you are at 50% — that would mean you had half your budget left.

I remember working on a procurement audit a few years back where a vendor invoice came in at 94.73% of the approved budget line. The person who ran the numbers initially reported it as "under budget" without actually confirming the percentage was calculated correctly. When I recalculated it the right way, the division was backwards — they had put the budgeted amount over the actual spend, which flipped the result to about 105%. The fix was renaming the columns in the spreadsheet to "Actual" and "Budgeted" and forcing the formula to reference them by name instead of by cell position. This prevented anyone from accidentally swapping them again. Column naming is not glamorous but it eliminated about three hours of manual reconciliation each month. Common edge cases: Zero is a real problem. If the denominator is zero, the result is undefined. You cannot express anything as a percentage of nothing. In practice this shows up in reports where a field was blank or defaulted to zero, and the formula returns an error or an absurdly large number. Always add a check — if the denominator equals zero, return "N/A" or flag the row. It takes about thirty seconds to add and saves you from publishing nonsense.

Decimal precision is another practical gotcha. The raw division might give you 0.33333333. If you multiply by 100 without rounding, you get 33.333333%. Most people want one or two decimal places. In Excel or Google Sheets, wrap the formula in ROUND(). Round to two decimals for financial reporting, one decimal for most dashboards. If you leave it unrounded and the numbers feed into further calculations, the extra precision can cascade and create small mismatches that look like errors when they are not. One more thing people get wrong: treating percentages as absolute values when they are relative. A 20% increase from 50 is 60. A 20% decrease from 60 is 48, not 50. The base changes. If you are comparing percentage movements over time, always confirm which base year or reference point the percentage is calculated against. Otherwise you end up with two percentages that look similar but measure different things. I use this workflow now. Define the part, define the whole, confirm the denominator is not zero, divide, multiply by 100, round to two decimals, label the result with the base it refers to. It is the same process every time. The only variation is whether the result is below 100 or above it, which just means you are measuring either a portion of something or an overshoot. Either way, the math does not change.

If you need to automate this across a large dataset, a simple spreadsheet formula works fine. For thousands of rows or repeated calculations, a script that applies the same formula consistently will cut manual effort to almost nothing. The trick is making sure the formula references stay locked when you copy it down. Absolute references prevent the denominator from shifting row by row and breaking the calculation. I also recommend documenting the formula once somewhere visible in the workbook or report footer. Not as a footnote, just a plain sentence: "Percentage = Actual ÷ Budget × 100." It takes five seconds to write and it stops three different people from rederiving it differently and ending up with three versions of the same number in one report.