How to Work Out Percentages in Google Sheets Easily

To work out a percentage in Google Sheets, divide the part by the total, then format the result as a percentage. For example, if 25 is in B2 and 200 is in C2, enter =B2/C2 in D2 and choose Format > Number > Percent; the result is 12.5%. You can also calculate a percentage of an amount or the percentage change between two values using other simple formulas.

The examples below are for Google Sheets in a web browser. You will need a spreadsheet and the numbers you want to compare. The same basic division and multiplication formulas work in Excel, although menu names or locations can differ slightly depending on the Excel version.

What You’ll Need

A Google account with access to Google Sheets and a spreadsheet open in a web browser.
The values for your calculation, arranged so you can identify the part, total, original value, or amount clearly.
Basic familiarity with selecting a cell and typing a formula. Formulas in Sheets begin with an equals sign.

Step-by-Step

Choose the percentage calculation you need. A percentage usually describes how much one value represents out of another. If you want to find what share a part is of a total, divide the part by the total. If you want to calculate a percentage of a price or quantity, multiply the amount by the percentage. If you want to compare a new value with an old one, calculate the change relative to the old value. Picking the right operation first prevents a common error: using a percentage formula that answers a different question.
Set up your values in separate cells. For a share-of-total calculation, type the part in B2 and the total in C2. For example, enter 25 in B2 and 200 in C2. Add labels such as Part and Total in B1 and C1 so you can understand the sheet later. For other calculations, label cells clearly too, such as Original amount and Discount rate. Keeping inputs separate makes it easier to check or update your numbers without rewriting the formula.
Calculate a part as a percentage of a total. With the part 25 in B2 and the total 200 in C2, click D2 and enter =B2/C2. The result is 0.125, which is the decimal form of 12.5%. The division is the calculation; percentage formatting changes how Sheets displays the result. If your values are in different cells, replace B2 and C2 with the correct references, keeping the part first and the total second.
Format the result as a percentage. Select D2, then choose Format > Number > Percent. Google Sheets displays 12.5% rather than 0.125. You can also use the percent-format button in the toolbar when it is visible. To show more or fewer decimal places, use the increase or decrease decimal place buttons on the toolbar. For example, 0.125 may display as 13% when rounded to zero decimal places, even though the underlying value remains 0.125.
Calculate a percentage of an amount when needed. Suppose a product costs 200 and you need to find 15% of its price. Put 200 in A2 and enter 15% in B2. In C2, enter =A2*B2. The result is 30, the amount equal to 15% of 200. If you want to calculate the price after a 15% discount, subtract that result from the original price. With 200 in A2 and 15% in B2, enter =A2*(1-B2) in C2; the result is 170. Format C2 as currency if the value represents money.
Work out percentage change between two values. Put the original value in A2 and the new value in B2. For example, if A2 is 80 and B2 is 100, enter =(B2-A2)/A2 in C2. The result is 0.25, or 25% after percentage formatting, meaning the value increased by 25% from the original. If the new value is 60 instead, the result is -25%, showing a decrease. The original value must be the denominator because the change is measured relative to where the value started.
Copy a calculation down a column if you have multiple rows. Enter a suitable formula in the first result row, then select that cell and drag the small blue square at its lower-right corner down across the rows you need. Sheets adjusts relative references as it fills the formula. For example, with each row holding a part in column B and a total in column C, the formula in D2 will adjust for row 3, row 4, and so on. Check a later row to confirm its formula points to the values on that same row.
Check the result against the question you are answering. Ask whether the result should be a percentage, a quantity, or a remaining amount. A share calculation such as 25 divided by 200 should be 12.5%; the amount represented by 15% of 200 should be 30; and the price after a 15% discount should be 170. These checks help catch reversed references, an incorrect starting value, or a result that has been formatted in the wrong way.

Common Mistakes

Multiplying when you should divide. To find what percentage one value is of another, divide the part by the total. Multiplying the two values does not give the share. Multiplication is appropriate when you already know a percentage and want to find its amount, such as 15% of a price.

Entering a whole number as though it were a percentage. If you type 15 into a cell and apply percentage formatting, Sheets displays 1,500%, because the value 15 is equivalent to 1,500%. For fifteen percent, type 15% or enter 0.15 and then apply percentage formatting. The displayed format does not change the underlying value.

Using the wrong denominator for a change. Percentage increase or decrease is measured against the original value, not the new value. Dividing the difference by the new value answers a different question and produces a different result. Keep the starting value as the denominator when comparing before and after.

Confusing percentage points with percent change. If a rate moves from 10% to 15%, it rises by 5 percentage points. Relative to its original 10% level, that is a 50% increase. State which comparison you mean, particularly when reporting rates, survey results, or performance measures.

Rounding too early. A displayed result may be rounded while the spreadsheet retains additional decimal places for later calculations. Avoid replacing precise values with rounded figures unless you specifically need to. Instead, adjust the number of displayed decimal places or use a rounding function only when the calculation requires rounded values.

Tips

Use descriptive column headings such as Part, Total, Share, Original, and New value. Clear labels make formulas easier to review and help other people understand the sheet. For a reusable template, keep input values in one area and calculated results in another, and apply a consistent number format to each type of value.

Enter percentages with the percent sign when practical. Typing 12.5% stores the decimal value 0.125, which Sheets can use directly in multiplication. If you enter 0.125 instead, applying percentage format will display 12.5%. This is useful when importing or copying data, because the same-looking numbers can represent different underlying values depending on how they were entered.

Use percentage formatting for a share or change result, but use currency or a regular number format for an amount. For example, a calculated discount amount of 30 is not 30%; it is 30 units of currency. A discount rate of 15% should remain a percentage. Applying the right format makes a sheet easier to read without altering the arithmetic.

When a total appears in several rows, you may want every formula to refer to one fixed total cell. In that situation, use an absolute reference for the total, such as $C$2, while allowing the part reference to change as you copy the formula down. For instance, with each row’s part in B2:B5 and the shared total in C2, enter =B2/$C$2 in D2 and fill it down. If B2 is 25 and C2 is 200, the first result is 12.5%. The dollar signs lock the total reference during copying.

Excel uses the same underlying percentage idea: divide a part by a total, then apply percentage formatting. In Excel for Microsoft 365, percentage formatting is also available from the number-format controls, though the interface differs from Google Sheets. If you share the spreadsheet with an Excel user, check that the formulas and displayed values remain clear after export or conversion.

Troubleshooting

The result shows 0.125 instead of 12.5%. The calculation may be correct but the cell is in a decimal or automatic format. Select the result cell and choose Format > Number > Percent. Add decimal places if you need to display a more precise value.

The result is 1,250% instead of 12.5%. Check whether you entered 12.5 as a plain number and then applied percentage formatting. Sheets treats 12.5 as twelve and a half, or 1,250%. Enter 12.5% or 0.125 for twelve and a half percent, then format the cell as a percentage if needed.

The formula gives an error or does not calculate. Confirm it begins with an equals sign, that referenced cells contain numeric values, and that the cell references point to the intended inputs. Check for accidental spaces or text characters in the number cells. If a value was pasted with a currency symbol or other text, try re-entering it as a number and applying a currency format afterward.

The percentage is unexpectedly negative. In a change calculation, a negative result means the new value is below the original value. Check that the old and new values are in the right cells and that the formula subtracts the original from the new value. A negative share-of-total result, however, may mean one of the inputs is negative when it should not be.

You see a division-by-zero error. The total or original-value cell used as the divisor may be zero or blank. Check that the denominator contains the intended nonzero value before calculating a share or percentage change. If a zero total is legitimate, decide how you want the sheet to represent that situation rather than treating the percentage as a normal result.

Copied formulas keep using the wrong total. If every row should use one shared total, edit the formula to lock that cell with dollar signs, such as $C$2, before filling down. If each row should use its own total, do not lock the row reference. Review the formula in a copied row to make sure it refers to the correct cells.

Frequently Asked Questions

How do I calculate what percentage one number is of another in Google Sheets?
Divide the part by the total, then apply percentage formatting. For example, if 25 is the part and 200 is the total, the result is 12.5%.

How do I find 20% of a number?
Multiply the number by 20%. For example, if 150 is in A2 and 20% is in B2, enter =A2*B2 in C2. The result is 30.

How do I calculate a percentage increase or decrease?
Subtract the original value from the new value, then divide that difference by the original value. Format the result as a percentage. A positive result is an increase and a negative result is a decrease.

Why does Google Sheets show a decimal instead of a percentage?
A percentage is stored as a decimal, so 12.5% is stored as 0.125. Select the cell and choose Format > Number > Percent to display it as a percentage.

Can Google Sheets calculate percentages automatically for a whole column?
Yes. Enter the formula in the first result row and drag its fill handle down. Check that references adjust as intended, and use dollar signs around any cell reference that should stay fixed.

Does percentage formatting change the formula result?
No. It changes how the value is displayed, not the value used in calculations. A displayed 12.5% is still stored as 0.125, so later formulas can use it as a percentage rate.

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.