Calculate Percentage 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 A2 contains 25 and B2 contains 200, enter =A2/B2 in C2 and choose Format > Number > Percent; the result is 12.5%.

The basic percentage formula

A percentage expresses one amount as a fraction of another amount, scaled to a base of 100. The general calculation is part divided by total. In a spreadsheet, that usually means placing the part and total in separate cells and dividing the first cell by the second.

With the part in A2 as 25 and the total in B2 as 200, enter this in C2:

=A2/B2

The result is 0.125, which is the same value as 12.5%. Google Sheets stores the underlying value as a decimal; percentage formatting changes how it is displayed, not the underlying calculation. You can also type the formula directly into a cell by selecting it, entering the equals sign and cell references, and pressing Enter.

The order matters: divide the part by the total, not the total by the part. If 25 is the part and 200 is the whole, reversing the references would produce 800%, which answers a different question. Before writing a formula, identify what amount should be treated as the whole.

Format the answer as a percentage

After entering a division formula, select the result cell or cells and use the Google Sheets menu path Format > Number > Percent. You can also click the % button in the toolbar. A decimal such as 0.125 will then appear as 12.5%, while its stored value remains 0.125.

Formatting is not the same as multiplying by 100. If you multiply the decimal result by 100 and then apply percentage formatting, Sheets scales the display again. For example, a stored value of 12.5 formatted as a percentage displays as 1,250%, not 12.5%. In most percentage calculations, divide the part by the total and apply percentage formatting without multiplying by 100.

To control how many digits appear after the decimal point, use the increase or decrease decimal places buttons in the toolbar after selecting the cell. Displaying one decimal place can make a result such as 12.5% easier to read, while a whole-number display may be suitable for a high-level summary. Changing the display precision does not necessarily change the stored value.

It is also possible to type a percentage directly into a cell, such as 12.5%. Sheets interprets it as the decimal value 0.125. By contrast, typing 12.5 and then applying percentage formatting displays 1,250%. Knowing this distinction helps prevent accidental scaling errors.

Calculate each item’s percentage of a total

Percentages of a shared total are common in budgets, survey results, sales reports, and inventory summaries. Suppose B2:B5 contains four category amounts—120, 180, 200, and 300—and B6 contains their total, 800. To find the share represented by the first category, enter this in C2:

=B2/$B$6

The result is 15%, because 120 divided by 800 equals 0.15. The dollar signs make B6 an absolute reference: if you copy the formula down, the row reference to the category amount changes, but the reference to the total stays fixed. Copy or drag the formula from C2 through C5 to calculate each category’s share. The four displayed percentages add up to 100% when the category values sum to the total.

If the total is not already in a cell, you can calculate it separately. With category amounts in B2:B5 and the total intended for B6, enter this in B6:

=SUM(B2:B5)

For those example amounts, B6 returns 800. Then use the percentage formula in the previous example for each category. Keeping the total in its own cell makes the calculation easier to audit and update when amounts change.

Make sure the denominator represents the correct total. A category’s share of a department total differs from its share of the whole company’s total. If the denominator includes only part of the data, the resulting percentages may not add up to 100% across the categories you are comparing.

Calculate percentage increase or decrease

To measure how much a value changed relative to its starting value, subtract the old value from the new value, then divide that difference by the old value. Suppose A2 contains the old value, 80, and B2 contains the new value, 100. Enter this in C2:

=(B2-A2)/A2

The result is 0.25, or a 25% increase. If the new value were 80 and the old value were 100, the same formula would return -0.2, or -20%, indicating a decrease. Format the result as a percentage so the sign and scale are easy to interpret.

The starting value belongs in the denominator because the question is how large the change is compared with where the measurement began. Dividing by the new value instead answers a different question and produces a different percentage. This distinction matters in year-over-year comparisons, price changes, and tracking progress over time.

If the old value is zero, the percentage change cannot be calculated with ordinary division because division by zero is undefined. Sheets will show an error rather than a meaningful percentage. In that situation, report the absolute change or explain that the percentage comparison is not applicable; do not present a made-up percentage.

Use the right formula for targets and comparisons

A target calculation is different from a change calculation. If the actual result is 45 and the target is 60, the share of the target achieved is 75%. With the actual amount in B2 and the target in C2, enter this in D2:

=B2/C2

Format D2 as a percentage. A value above 100% means the actual amount exceeded the target; a value below 100% means it did not reach the target. This formula measures attainment, not growth from a previous period. Choose the formula that matches the question instead of treating every percentage as a percentage change.

Another common distinction is percentage change versus percentage-point change. If a rate moves from 40% to 46%, it rises by 6 percentage points. Its relative percentage increase is 15%, because the six-point rise is 15% of the original 40% rate. These describe different things and should not be used interchangeably.

With the earlier rate in A2 as 40% and the later rate in B2 as 46%, enter this in C2 to find the difference:

=B2-A2

The result is 6 percentage points when the cell is formatted as a percentage and displays 6%. The formula returns a difference between two stored decimal rates; describe it as percentage points, not as a 6% relative increase. To calculate relative growth in the rate, use the percentage-change method with the earlier rate as the starting value.

Copy formulas and check common errors

When a percentage formula needs to be repeated for many rows, write it once and use the fill handle—the small square at the lower-right corner of the selected cell—to drag it down. Relative references adjust as the formula moves. If a denominator must remain fixed, use dollar signs around its column and row, as in the total example above. This is called an absolute reference.

When a result looks wrong, check these common causes:

Wrong denominator: Confirm that the cell you divide by is the total or starting value relevant to the question.
Double scaling: Do not multiply a percentage result by 100 and also apply percentage formatting unless that is specifically intended.
Text instead of numbers: Values imported with extra symbols, spaces, or text formatting may not behave as numeric values. Check the source cells and their formats.
Zero or blank denominator: A zero denominator produces a division error. A blank denominator may also lead to an error or an unhelpful result; check whether the data is complete before interpreting it.
Rounding expectations: A displayed 10% may represent a more precise underlying value. Increase the displayed decimal places if you need to inspect the detail.

Google Sheets menus and formula separators can vary with spreadsheet locale. The examples here use commas where function arguments are needed and the standard English-language formula style. In some locales, Sheets may expect semicolons between function arguments. If a formula is rejected, check File > Settings for the spreadsheet’s locale and use the separator expected there.

Rounding, precision, and interpreting results

Percentage formatting lets you choose what readers see without necessarily changing the precision used in later calculations. For example, a value may display as 33.3% while the underlying result is 0.333333…. Calculations that refer to that cell generally use the underlying value, not just the rounded text shown on screen.

This is usually desirable: retaining precision reduces the effects of rounding across a series of calculations. If a report requires figures that add to exactly 100% as displayed, the displayed values may differ slightly because each category has been rounded separately. Explain the rounding convention or show an appropriate number of decimal places rather than assuming that a small visible discrepancy means the calculation is broken.

For quick checks, test the arithmetic with simple values. If a part is half of a total, the result should be 50%; if it equals the total, the result should be 100%. For percentage change, compare the sign with the direction of movement: an increase should normally be positive, and a decrease negative. These checks can reveal swapped references or an incorrect starting value.

Frequently Asked Questions

What is the basic percentage formula in Google Sheets?
Divide the part by the total, then format the result as a percentage. For example, 25 divided by 200 equals 0.125, which displays as 12.5% when formatted as a percentage.

Why does my percentage formula show a decimal?
The calculation returns a decimal value, which is how Sheets stores percentages. Select the result and choose Format > Number > Percent, or click the % toolbar button, to display it as a percentage.

Should I multiply the formula by 100?
Usually, no. Divide the part by the total and apply percentage formatting. Multiplying by 100 and then applying that formatting will make the displayed number 100 times too large.

How do I calculate a percentage increase?
Subtract the old value from the new value and divide by the old value. Format the result as a percentage; a positive result indicates an increase and a negative result indicates a decrease.

How can I calculate a percentage if the total is zero?
A percentage with zero as its denominator is undefined, so a standard division formula cannot produce a meaningful result. Report the absolute amount or mark the percentage as not applicable, and explain why it cannot be calculated.

Why do my percentages not add up to exactly 100%?
They may be rounded for display, or the category values may not cover the whole total. Check the underlying amounts and denominator, then show more decimal places if rounding is the only difference.

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.