Google Sheets Percentage Calculator: Formulas and Examples

To use Google Sheets as a percentage calculator, enter the part and the total in cells, then divide the part by the total—for example, with a part in B2 and a total in C2, enter =B2/C2 and choose Format > Number > Percent. For a percentage of a number, multiply the number by the percentage, such as 200 multiplied by 15% to get 30.

How percentage calculations work in Sheets

A percentage is a ratio expressed out of 100. In a spreadsheet, the value 15% is stored as 0.15, so a percentage calculation usually produces a decimal that you can display as a percent. Formatting changes how the value appears; it does not change the underlying calculation.

For example, if 18 items out of 60 are defective, dividing 18 by 60 gives 0.3. Displaying that result as a percent shows 30%. The distinction matters: if the formula returns 0.3 and you type another multiplication by 100 into the formula, then format the result as a percent, Sheets will show 3,000% instead of 30%.

Google Sheets does not require a special percentage-calculator function. Ordinary arithmetic operators—division, multiplication, addition, and subtraction—cover the common calculations. A formula is useful when values may change, because the answer updates automatically when the referenced cells change.

Calculate what percent one value is of another

Use this method to find a share, completion rate, discount rate, or other part-to-whole percentage. Put the part in one cell and the whole in another, divide the part by the whole, and format the result as a percentage.

Enter the part in B2 and the total in C2.
In D2, enter =B2/C2. With B2 set to 18 and C2 set to 60, the raw result is 0.3.
Select D2 and choose Format > Number > Percent. The displayed result is 30%.

The denominator should represent the whole you mean to compare against. If a class has 18 students who passed out of 20 students who took the test, 18 divided by 20 gives a 90% pass rate. Dividing by the class roster of 24 instead would answer a different question: the percentage of all enrolled students who passed.

Find a percentage of a number

To work out a proportion of an amount, multiply the amount by the percentage. This can calculate a tip, a discount amount, a sales target, or a tax estimate. If the percentage is entered as 15%, Sheets treats it as 0.15 for calculation purposes.

For example, with an amount of 200 in A2 and a rate of 15% in B2, enter =A2*B2 in C2. The result is 30. If you want to show the original amount plus that increase, add the amount and the calculated portion; if you want the amount after a discount, subtract the discount amount from the original.

You can also type the percentage directly into a formula. With the original value 200 in A2, =A2*15% returns 30. Keeping the rate in a separate cell is usually easier to maintain: changing B2 from 15% to 12% updates the answer without editing the formula.

Calculate percentage increase or decrease

Percentage change compares a new value with an old value. Subtract the old value from the new one, then divide that difference by the old value. A positive result indicates an increase; a negative result indicates a decrease. Format the result as a percentage to make it easier to read.

Suppose last month’s sales are in A2 and this month’s sales are in B2. Enter =(B2-A2)/A2 in C2. If A2 is 80 and B2 is 100, the calculation is (100 − 80) ÷ 80, so C2 displays 25% when formatted as a percent. If B2 is 60 instead, the result is −25%, a decrease.

The old value is the denominator because the question is how large the change is relative to the starting point. Reversing the order or dividing by the new value gives a different measure. When the old value is zero, percentage change is undefined because division by zero is not possible. Decide how to label that case rather than treating it as an ordinary percentage.

Work backward from a percentage

Sometimes you know a portion and its rate and need to recover the whole. Divide the portion by the percentage written as a decimal. For example, if 30 is 15% of a total, the total is 30 divided by 0.15, which equals 200.

With the portion in A2 and the rate in B2, enter =A2/B2 in C2. If A2 is 30 and B2 is 15%, C2 returns 200. Make sure B2 contains a percentage value such as 15%, not the plain number 15; dividing by 15 would return 2 and answer a different calculation.

This is useful for estimating an original price from a known discount amount or finding a full target from a completed share. It does not, by itself, reverse every price adjustment: recovering a pre-discount price from a discounted final price requires dividing the final price by the remaining proportion, such as 85% after a 15% discount.

Enter and format percentages correctly

In Google Sheets in a web browser, select the cells and choose Format > Number > Percent. You can also use the percent button in the toolbar. To show more or fewer decimal places, use the toolbar’s decimal-place controls. Formatting a cell as a percentage makes a value such as 0.25 display as 25%; it does not turn the number 25 into 25%.

When you type 15% directly into a cell, Sheets stores the decimal equivalent, 0.15. If you type 15 and then apply percentage formatting, Sheets displays 1,500%, because the underlying value is fifteen, or 1,500 hundredths. To represent fifteen percent, enter 15% or enter 0.15 and then apply percentage formatting.

Choose decimal places that suit the information. A whole-number rate may be clear for a simple survey result, while a rate such as 3.75% may need two decimal places for a detailed comparison. Extra displayed precision does not make the source data more accurate; it only changes how many digits are shown.

Common mistakes and troubleshooting

Getting 3,000% instead of 30%: The formula may multiply by 100 and the cell may also be formatted as a percent. Divide the part by the total and apply percent formatting once.
Getting 1,500% for fifteen percent: The cell contains 15 rather than 15%. Enter 15% or 0.15.
Seeing an error from a zero total: A percentage-of-total calculation cannot divide by zero. Check that the total cell contains the intended nonzero value.
Getting a negative percentage change: This is expected when the new value is lower than the old value. Confirm that the old and new cells have not been swapped.
Seeing too many decimal places: Change the displayed precision with the toolbar controls; do not alter the formula just to make the result look shorter.

Also check that the referenced cells contain numbers rather than text that merely looks numeric. Imported data can include spaces, currency symbols, or other characters that prevent a value from behaving as expected. If a result seems wrong, click the cell and inspect the formula bar as well as the displayed format.

Use a calculator layout for repeated work

For a one-time calculation, two input cells and a result cell are enough. For recurring work, label the columns so another person can tell what the numbers mean. A simple table might use columns named Item, Part, Total, and Percent, with one row per item. Copying the formula down then calculates each row using its own part and total.

Keep the input cells separate from the formula cells. That makes it easier to update a rate or amount without accidentally overwriting a calculation. You can also format inputs as percentages where appropriate and use a distinct fill color or label for calculated results. If the sheet will be shared, add a short note defining what counts as the part and what counts as the total; many percentage disagreements are really differences in the chosen denominator.

For calculations involving money, the arithmetic can estimate a percentage amount, but a spreadsheet does not establish the actual terms of a purchase, loan, tax, or fee. Use the relevant contract or official source for the applicable rate and rules, and check real terms with the lender or a qualified professional when needed.

Frequently Asked Questions

What is the formula for percentage in Google Sheets?
For a part in B2 and a total in C2, divide the part by the total with =B2/C2, then format the result as a percentage using Format > Number > Percent.

How do I calculate 20% of a number in Google Sheets?
Multiply the number by 20%. For a value in A2, enter =A2*20%. If A2 is 150, the result is 30.

How do I calculate percent change in Google Sheets?
With the old value in A2 and the new value in B2, use =(B2-A2)/A2 and format the answer as a percentage. The formula compares the difference with the old value.

Why does Google Sheets show 1,000% instead of 10%?
The cell likely contains 10 rather than 0.10 or 10%. Percent formatting displays the stored number multiplied by 100. Enter 10% or 0.10 for a ten-percent value.

Can Google Sheets calculate a percentage automatically?
Yes. A formula recalculates when its referenced inputs change. For repeated calculations, put the inputs in separate cells and use a formula that refers to those cells rather than retyping fixed numbers.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.