How to Compute a Percentage in Google Sheets

To compute a percentage in Google Sheets, divide the part by the total, then format the result as a percentage. For example, if A2 contains 15 and B2 contains 60, enter =A2/B2 in C2; the result is 0.25, which displays as 25% when you apply percentage formatting. You can use the same approach for shares, completion rates, discounts, and many other everyday calculations.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
Numbers entered into cells, such as a part and a total, or an earlier value and a later value.
A clear idea of what the percentage should describe. A share of a total and a percentage increase are different calculations.

You do not need to install an add-on or use a special percentage function. Basic division and, when useful, subtraction or multiplication are enough. The examples below use ordinary cell references, so you can replace them with the cells in your own sheet.

Step-by-Step

Decide what you want the percentage to mean. For a part-to-whole percentage, identify the part and the total. For example, if 15 of 60 orders were delivered late, 15 is the part and 60 is the total. For a change percentage, identify the starting value and the new value. Write down which cells contain each figure before building a formula; switching the values can change the meaning or the sign of the result.
Enter the figures in separate cells. In a blank sheet, you might enter a label such as Late orders in A2, the value 15 in B2, a label such as Total orders in A3, and 60 in B3. Labels are optional, but they make a sheet easier to check later. Keep the cells used in calculations numeric: type 15 rather than 15 orders, and add units in a nearby label instead of inside the number cell.
Divide the part by the total. With the part in B2 and the total in B3, select an empty result cell such as B4 and enter =B2/B3. For the example, 15 divided by 60 equals 0.25. This decimal is the underlying result; it is not an error. Percentage formatting changes how the value is shown, not the underlying calculation.
Format the result as a percentage. Select B4, then choose Format > Number > Percent from the Google Sheets menu. The cell should show 25%. You can also use the percentage-format button on the toolbar when it is visible. Do not multiply the formula by 100 as well as applying percentage formatting, or the displayed value will be 2,500% instead of 25%.
Choose how many decimal places to show. Percentage formatting may show a whole percentage by default. Use the toolbar buttons for increasing or decreasing decimal places if you need a more precise display. For example, a ratio of 1 divided by 3 is stored as approximately 0.3333; it may display as 33%, 33.3%, or 33.33% depending on the number of displayed decimal places. Changing the display does not change the stored value.
Calculate each row’s share of a total. Suppose monthly sales are in B2:B5 and their combined total is in B6. First, with those sales values in B2:B5, calculate the total in B6 using =SUM(B2:B5). If the values are 120, 80, 50, and 150, B6 returns 400. Then, with the first month’s sales in B2 and the total in B6, enter =B2/$B$6 in C2. The first month’s share is 30%. Format C2 as a percentage, then drag its fill handle down to copy the formula for the other rows. The dollar signs keep the total reference fixed as the formula copies down; the sales reference changes to B3, B4, and B5.
Calculate a percentage increase or decrease. A change percentage compares the difference with the original, or starting, value. If the original amount is in B2 and the new amount is in C2, enter =(C2-B2)/B2 in D2. With B2 equal to 80 and C2 equal to 100, the difference is 20 and 20 divided by 80 equals 0.25, so D2 displays 25% when formatted as a percentage. A negative result indicates a decrease: if the new value were 60 instead, the result would be -25%.
Work out a discount or remaining portion. If A2 contains an original price of 60 and B2 contains a discount rate of 15%, format B2 as a percentage and enter =A2*(1-B2) in C2. The result is 51 because 60 multiplied by 0.85 equals 51. This calculates the price after the discount, not the discount amount. To calculate only the discount amount with the same cell layout, use =A2*B2; the result is 9. Make sure B2 contains the rate as 15% or 0.15, not the whole number 15.
Check the result against the question. For a part-to-whole calculation, the answer should usually be between 0% and 100% if the part cannot exceed the total. For a change calculation, a negative percentage can be valid, and an increase can exceed 100%. Check that you used the right starting value as the denominator and that the output cell is formatted as a percentage before sharing or relying on the sheet.

Google Sheets uses the same division-based arithmetic as Excel for these examples. In Excel for Microsoft 365 on Windows, you can also select the result and use Home > Number > Percent Style; the basic formulas remain the same. The menu path named in the steps above is for Google Sheets in a browser.

Common Mistakes

Multiplying by 100 and formatting as a percent. Dividing 15 by 60 gives 0.25. Percentage formatting displays that as 25%. If you also multiply the formula result by 100, the value becomes 25 before formatting and displays as 2,500%.
Using the wrong denominator. A part-to-whole percentage uses the whole as the denominator. A change percentage uses the original value as its denominator. Dividing a change by the new value instead of the starting value answers a different question.
Typing the percent sign into a formula result unnecessarily. A formula should return a number, such as 0.25, and the cell’s number format should display the percent sign. Entering a text result such as 25% in a formula can make later arithmetic harder.
Entering a whole-number rate instead of a percentage rate. If a discount cell contains 15, Sheets treats it as fifteen, not 15%. Enter 15% or 0.15 when you mean a fifteen-percent rate.
Ignoring blanks, zeroes, or totals that include the wrong rows. A total that omits a row or includes a heading can make every share look wrong. Check the range used for the total, especially after adding rows to a table.
Rounding the calculation too early. A displayed value of 33% might be stored as 33.3333%. Use formatting to control what readers see, and avoid replacing the underlying value with a rounded figure unless rounding is specifically part of the requirement.

Tips

Use descriptive headings. Headings such as Part, Total, and Percentage make it easier to verify which values a formula uses. For a change calculation, label the two inputs Original and New rather than relying on memory.
Lock a shared total when copying formulas. In the sales example, the reference to B6 uses dollar signs so it does not move when copied down. A relative reference such as B6 would shift to B7, B8, and so on, which could produce incorrect shares.
Choose precision to suit the task. Whole percentages are often readable in a summary, while rates used for detailed comparisons may need one or two decimal places. Keep the stored value intact and adjust the displayed decimals rather than changing the calculation.
Separate percentage points from percent change. If a rate rises from 20% to 25%, it rises by 5 percentage points. Its percentage increase is 25%, because the five-point difference is 25% of the original 20% rate. These expressions are not interchangeable.
Make the formula fillable. Put one result formula in the first data row, confirm it, then drag the small square at the cell’s lower-right corner down the column. Inspect the last few rows to confirm that changing references moved as intended and any fixed total stayed fixed.
Keep inputs and results visually distinct. You can use headings, borders, or a subtle fill color to distinguish entered values from calculated cells. This does not change the math, but it makes it less likely that someone will overwrite a formula while updating the data.

Troubleshooting

The result shows 0.25 instead of 25%. The division may be correct; the cell is probably using a decimal number format. Select it and choose Format > Number > Percent. If it still looks wrong, check that the value was not multiplied by 100 in the formula already.

The result shows 2,500% or another value 100 times too large. Remove an extra multiplication by 100 if the cell is formatted as a percentage. For a 15-out-of-60 example, division alone returns 0.25, which percentage formatting displays as 25%.

The formula returns #DIV/0!. The denominator is zero or the cell it references is blank. Check the total or original-value cell and make sure it contains a nonzero number. Do not replace the denominator with an arbitrary value simply to hide the error; correct the source data or decide how a zero-total case should be reported.

The formula is not calculating. Check that it begins with an equals sign and that the referenced cells contain numbers, not text that looks like numbers. Click the formula cell to inspect its references. If the cell displays the formula characters instead of a result, check whether the entry was treated as plain text; set the cell to Automatic under Format > Number and enter the formula again.

The copied formula gives odd percentages in later rows. Inspect the references in a copied cell. If the total moved along with the row, use an absolute reference for the total, such as dollar signs around both its column and row. If the part reference did not move, remove the dollar signs from that reference so it adjusts for each row.

The value is negative or over 100% and that seems unexpected. For a change calculation, a negative result means the new value is lower than the original, while a value above 100% means the increase is larger than the starting value. For a part-to-whole calculation, check that the part and total are correctly identified and that the total actually includes the part.

Frequently Asked Questions

What is the basic percentage formula in Google Sheets?
Divide the part by the total, then format the result cell as a percentage. For example, if the part is in A2 and the total is in B2, use =A2/B2. A result of 0.4 displays as 40% after percentage formatting.

Do I multiply by 100 in Google Sheets?
Usually, no. A division result such as 0.4 already represents 40%; applying percentage formatting displays it that way. Multiply by 100 only if you specifically need the numeric value 40 rather than a percentage-formatted value, and do not then format that value as a percentage.

How do I calculate what percentage one number is of another?
Divide the first number, the part, by the second number, the whole. With 18 in A2 and 24 in B2, enter =A2/B2 in C2 and format C2 as a percentage. The result is 75% because 18 divided by 24 is 0.75.

How do I calculate percentage change between two values?
Subtract the old value from the new value, then divide that difference by the old value. With the old value in A2 and the new value in B2, enter =(B2-A2)/A2 in C2. If A2 is 80 and B2 is 100, the result is 25%. The old value cannot be zero because division by zero is undefined.

Can the percentage be greater than 100%?
Yes. A percentage increase can exceed 100% when the new value is more than twice the starting value. A part-to-whole result can also exceed 100% if the part is greater than the stated total, though that may mean the inputs or the definition of total need checking.

How many decimal places should a percentage show?
Choose the display precision that suits the reader and the decision being made. A rounded display is convenient for a simple summary, while more decimals can help distinguish close results. Google Sheets retains the underlying value when you change displayed decimal places.

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.