Free tool

Percentage calculator

Three everyday percentage questions in one live sheet. Change any blue cell and the answers recompute, then copy the formula into your own spreadsheet.

fx=B3*B2/100
AB
1What is X percent of Y?
2Percent (%)
3Of
4Result12
5Y plus X percent92
6Y minus X percent68
7
8X is what percent of Y?
9Part
10Whole
11Percent25%
12
13Percent change from X to Y
14From
15To
16Change15%
17Difference12

Blue cells are inputs: type a new value and the sheet recomputes. Click a result to see its formula.

The formulas

How it works, step by step

=B3*B2/100
A percent of a number. Multiply the number by the percent and divide by 100: 15% of 80 is 80 × 15 / 100 = 12. Typed directly, =80*15% gives the same answer, because the % sign divides by 100.
=B3*(1+B2/100)
Add or take off a percent. Adding 15% is multiplying by 1.15, so 80 becomes 92. Taking 15% off is multiplying by 0.85: =B3*(1-B2/100) gives 68. This is how prices with tax and discounts are worked out.
=B9/B10
What percent one number is of another. Divide the part by the whole: 30 / 120 = 0.25. Give the cell a percent format to read it as 25%, or multiply by 100 if you want the plain number.
=(B15-B14)/B14
Percent change. Take the new value minus the old one, divided by the old one: (92 − 80) / 80 = 15%. A negative result is a decrease. Always divide by the starting value, not the new one.
On live data

The same formula on your Sheets data

The share of a store's sales that comes from one vendor, read live from its order lines: the same part-of-a-whole formula, on a whole table.

Sheets for Sheets

=data.order_lines.sum(net_amount, vendor, "Acme")/data.order_lines.sum(net_amount)
Sheets reads the table live from the connected account: no export, no copy-paste, and the result updates when the data does.

Functions used here

ROUNDRound to N decimalsABSAbsolute valueSUMSum of valuesPERCENTRANK.INCRank of x as a fraction from 0 to 1

More free tools

Credit card interest calculatorSee the interest on a credit card balance this month, how many months your payment takes to clear it, and the total interest, with the formulas behind each number.Cubic feet calculatorCalculate cubic feet from length, width and height in feet or inches, convert to cubic yards and cubic meters, and get the volume of a cylinder, with the formulas.Box and whisker plot makerPaste your numbers to draw a box and whisker plot with the minimum, quartiles, median, maximum, IQR and outliers, each worked out by a spreadsheet formula you can copy.Find duplicates in a listPaste a list to flag every duplicate, count the distinct values and list the ones that repeat, with the COUNTIF and UNIQUE formulas that do it in any spreadsheet.Multiply columns and add them upMultiply quantity by price on each row, sum the column, and get the same total in one SUMPRODUCT formula.Profit margin calculatorCalculate gross profit margin and markup from cost and price, or the selling price for a target margin or markup, with the spreadsheet formula for each.CAGR calculatorWork out the compound annual growth rate between a start and end value over any number of years, check it with RRI, and project future values with the same rate.
FAQ

Questions

How do I figure out a percentage of a number?

Multiply the number by the percentage, then divide by 100. For 15% of 80: 80 × 15 = 1,200, and 1,200 / 100 = 12. In a spreadsheet that is =80*15/100 or =80*15%.

How do I work out what percent one number is of another?

Divide the part by the whole and multiply by 100. 30 out of 120 is 30 / 120 = 0.25, which is 25%.

How do I calculate a percent change?

Subtract the old value from the new value, divide by the old value and multiply by 100. From 80 to 92 is (92 − 80) / 80 = 0.15, an increase of 15%. From 250 to 200 is −20%.

What is the difference between percent change and percentage points?

Percentage points are the plain difference between two percentages: a rate going from 10% to 12% rose by 2 percentage points. As a percent change it rose by 20%, because 2 is 20% of 10.

Why does adding 10% and then taking 10% off not give the original number?

The second percent is taken of a bigger number. 100 plus 10% is 110, and 10% of 110 is 11, so you end at 99. To undo an increase, divide by 1.10 instead.

Run these formulas on live data

Sheets is a spreadsheet with 491 functions that reads your store, accounting or project data live, builds dashboards and e-mails reports on a schedule.

See the integrationsAll free tools