Percentage Calculation in Google Sheets: Formulas & Tips

To calculate a percentage in Google Sheets, divide the part by the total, then format the result as a percentage. For example, if the part is in B2 and the total is in C2, enter =B2/C2 and select Format > Number > Percent; a result of 0.75 will display as 75%.

The Basic Percentage Formula

A percentage expresses a part as a fraction of a whole, multiplied conceptually by 100. In a spreadsheet, you normally do not multiply the division result by 100 if you plan to format it as a percentage: Google Sheets handles the display conversion. The underlying value for 75% is 0.75, which is why dividing the part by the total gives the right result.

With the part in B2 and the total in C2, use =B2/C2. If B2 is 36 and C2 is 48, the formula returns 0.75; percentage formatting displays 75%. You can also enter the division formula and leave the cell in a regular number format, in which case it will show 0.75 rather than 75%.

For a reliable setup:

Put the part and total in separate cells, with the part no larger than the total if you expect a percentage below 100%.
Select the cell where you want the answer.
Enter the division formula, using cell references rather than typing the numbers directly when you may update the data.
Apply percentage formatting and check that the displayed result makes sense.

A percentage can be greater than 100%. If a team completes 54 items against a target of 48, the calculation gives 112.5%. That is not a formula error; it means the part exceeded the chosen total.

Format a Result as a Percentage

In Google Sheets in a web browser, select the result cell or range, then choose Format > Number > Percent. You can also use the % button in the toolbar. Formatting changes how a numeric value appears; it does not change the underlying calculation. To show more or fewer decimal places, use the increase- or decrease-decimal-place controls on the toolbar, or adjust the number format from the Format menu.

Input method matters. Typing 15% into a cell stores the value as 0.15. Typing 0.15 and then applying percentage formatting also displays 15%. But typing 15 and applying percentage formatting displays 1,500%, because the stored value is fifteen, not fifteen hundredths. This is one of the most common reasons a result looks unexpectedly large.

Google Sheets and Excel use the same basic division approach and store percentages as decimal values. The menu layouts differ: the instructions here use Google Sheets’ Format menu, not Excel’s ribbon. If a spreadsheet uses a locale with different formula separators, Sheets may expect semicolons instead of commas; the examples here use the usual comma-separated syntax.

Find One Category’s Share of a Total

To calculate each category’s share, divide its amount by the sum of all category amounts. This is useful for survey answers, expense categories, sales by product, or any table where each row contributes to one overall total.

Suppose the amounts are in B2:B4. In C2, enter =B2/SUM($B$2:$B$4), format C2 as a percentage, and copy the formula down through C4. The dollar signs keep the total range fixed as you copy. If the amounts are 120, 80, and 50, their total is 250, so the results are 48%, 32%, and 20%. Together, they add to 100%.

Check that the values you include in the denominator match the question you are asking. If the range leaves out a category, the displayed shares will still calculate, but they will be shares of the smaller included total rather than of all activity. If the table contains subtotals alongside individual items, including both can count the same amount twice.

Calculate Percentage Increase or Decrease

Percentage change compares a new value with an old value. Subtract the old value from the new value, then divide that difference by the old value. A positive result indicates an increase; a negative result indicates a decrease.

With the old value in B2 and the new value in C2, use =(C2-B2)/B2. If the old value is 80 and the new value is 100, the difference is 20 and the percentage change is 20 divided by 80, or 25%. If the new value is 60 instead, the result is -25%, a decrease of 25%.

The starting value is the denominator because the question is how large the change is relative to where the measurement began. Reversing the order changes the meaning. For instance, a rise from 80 to 100 is 25%, but a fall from 100 back to 80 is 20%. The absolute difference is 20 in both cases; the starting amounts are different.

If the old value might be zero, division by zero will produce an error. Decide how you want the sheet to treat that situation instead of interpreting it as a normal percentage change. With the old value in B2 and the new value in C2, this formula leaves the result blank when B2 is zero: =IF(B2=0,"",(C2-B2)/B2). A change from zero does not have a mathematically defined percentage increase under this standard calculation.

Calculate a Percentage of an Amount

Sometimes the question is not “what percentage is this part?” but “what is 15% of this amount?” Multiply the amount by the percentage. For example, if an amount is 240 and the rate is 15%, the result is 36.

With the amount in A2 and the percentage rate entered as 15% in B2, use =A2*B2. If A2 is 240, the formula returns 36. Enter the rate as 15% or 0.15; if you enter the number 15 without a percent sign or decimal conversion, the formula returns 3,600 instead.

This approach works for illustrative discounts, markups, or other simple rate calculations. For example, the discount amount is the original price multiplied by the discount rate; the discounted price is the original price multiplied by one minus that rate. With the original price in A2 and the discount rate in B2, the discounted-price formula is =A2*(1-B2). If A2 is 80 and B2 is 25%, the result is 60. These are arithmetic examples, not financial, tax, or investment advice; check actual terms with the relevant provider or a qualified professional when those terms matter.

Work Backward from a Percentage

You can also find the whole when you know a part and the percentage it represents. Divide the part by the percentage expressed as a decimal. For example, if 30 represents 20% of a total, the total is 150 because 30 divided by 0.20 equals 150.

With the known part in A2 and its percentage in B2, enter =A2/B2. If A2 is 30 and B2 is 20%, the formula returns 150. Make sure B2 contains a percentage value such as 20% or 0.2; a plain 20 would produce a result one hundred times smaller than intended. The rate must also be nonzero, since dividing by zero is undefined.

Common Errors and How to Check Them

When a percentage appears wrong, inspect the input values and the format before rewriting the formula. The calculation may be correct while the underlying value or the display is not what you expected.

The answer is 100 times too large: Check whether a rate such as 15 was entered where 15% or 0.15 was intended. Also check whether you multiplied by 100 and then applied percentage formatting, which would scale the display twice.
The cell shows a decimal: The division may be correct, but the cell is in a number format. Apply Percent using Format > Number > Percent.
The result is an error: Check whether the total or starting value is blank or zero. A percentage with a zero denominator cannot be calculated normally, so decide whether a blank, a message, or another treatment fits the sheet.
Copied formulas use the wrong total: Use absolute references for a fixed total range, such as $B$2:$B$4. Relative references move when a formula is copied; absolute references stay fixed.
Percentages do not add to 100%: Check for omitted categories, duplicate rows, or rounding. Values displayed with few decimal places can appear to add to 99.9% or 100.1% even when the underlying values sum to 100%.

For a quick validation, calculate the part and total independently, then check whether the percentage multiplied by the total gives approximately the part. For a share-of-total table, check that the contributing rows are complete and that their displayed percentages are close to 100% in total. Small display differences can result from rounding; increasing decimal places can reveal whether the stored values are consistent.

Percent Versus Percentage Points

A percentage change and a percentage-point change describe different things. If a rate rises from 18% to 21%, it has increased by 3 percentage points. Relative to its original 18% level, the increase is 3 divided by 18, or about 16.67%.

This distinction matters when comparing rates such as survey results, interest rates, or conversion rates. Saying “up 3%” could mean a relative increase of 3%, while “up 3 percentage points” means the displayed rate itself rose by three points. State which measure you calculated so readers do not mistake one for the other.

Frequently Asked Questions

How do I calculate 20% of a number in Google Sheets?
Multiply the number by a rate entered as 20% or 0.2. If the number is in A2 and the rate is in B2, the calculation is =A2*B2. A value of 150 with a 20% rate gives 30.

Why is Google Sheets showing 1,500% instead of 15%?
The cell likely contains the number 15, then has percentage formatting applied. Percent formatting interprets 1 as 100%, so 15 displays as 1,500%. Enter 15% or 0.15 to display 15%.

How do I show two decimal places in a percentage?
Select the cell and apply Format > Number > Percent, then use the toolbar’s increase-decimal-place control until two places appear. For example, the display can show 12.50% instead of 13%, without changing the underlying value.

How do I calculate a percentage difference between two numbers?
For a change from an old value to a new value, subtract the old value from the new one and divide by the old value. The result is a percentage increase or decrease. If you mean the absolute difference without choosing a starting value, say so explicitly: “percentage difference” is sometimes used for a different comparison method.

Can I calculate a percentage when the total is zero?
Not with ordinary part-divided-by-total arithmetic: division by zero is undefined. A zero total needs a deliberate reporting choice, such as leaving the result blank or displaying a note, rather than treating the result as 0% automatically.

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.