The Basic Formula for Any Percentage

To calculate a percentage in Google Sheets, divide the part by the whole, then multiply by 100. The formula is =(part/whole)*100. If you want to show the result as a percentage format instead of a decimal, you can skip the multiplication by 100 and format the cell as a percentage instead — Google Sheets will do the multiplication for you.

For example, if you sold 45 items out of 200 total items, the formula would be =45/200 in the cell, then format that cell as a percentage. Google Sheets displays it as 22.5%. If you prefer to write it as =(45/200)*100, the result shows as 22.5 without percentage formatting.

The most common approach is to use the division formula and let the percentage format handle the display. This keeps your spreadsheet cleaner and makes it easier to use those percentages in other calculations later.

Key Takeaways

  • The percentage formula is always (part ÷ whole) × 100, or you can divide and format the cell as a percentage to skip the multiplication step.
  • Use cell references like =A2/B2 instead of typing numbers directly, so you can copy the formula down to other rows.
  • Format cells as percentage by selecting them, right-clicking, choosing Format Cells, and picking Percentage from the menu.
  • To calculate what a percentage of a number is (like 20% of 500), use the formula =number*percentage, such as =500*0.20.

Using Cell References Instead of Numbers

When you have data in columns, reference the cells instead of typing numbers into the formula. If column A holds your parts and column B holds your wholes, write =A2/B2 in cell C2. This formula pulls the values from those specific cells.

Once you enter the formula in C2, click the small square at the bottom right corner of the cell and drag it down to copy the formula to the rows below. Google Sheets automatically adjusts the cell references — C3 becomes =A3/B3, C4 becomes =A4/B4, and so on. This saves time when you have dozens or hundreds of rows.

If you need the formula to always reference the same cell (like a total in B10), use a dollar sign: =A2/$B$10. The B10 stays fixed when you copy the formula down, but A2 changes to A3, A4, and so on.

Formatting Cells to Display as Percentages

After you write your division formula, select the cell or cells that hold the result. Right-click and choose Format cells. In the menu that opens, click Percentage from the list on the left. Google Sheets multiplies your decimal by 100 and adds the % symbol automatically.

You can also select the cells and use the toolbar: look for the % button near the top of the screen and click it. This applies percentage formatting when ready. If you want to control how many decimal places show (like 22.50% instead of 22.5%), right-click again, choose Format cells, and adjust the decimal places field.

Percentage formatting is purely visual — it does not change how Google Sheets uses the number in other formulas. A cell showing 22.5% still contains the decimal 0.225 underneath, so if you reference it in another calculation, it works correctly.

Calculating What a Percentage of a Number Is

Sometimes you need to find what 20% of 500 equals, rather than what percentage 100 is of 500. The formula is =number*percentage. If the number is in cell A2 and the percentage is in cell B2, write =A2*B2.

Enter the percentage as a decimal: 20% becomes 0.20, 15% becomes 0.15, 5% becomes 0.05. If your percentage is already formatted as a percentage in the cell, Google Sheets reads it correctly — you can write =500*B2 where B2 contains 20% and get the right answer.

This is useful for calculating discounts, tax amounts, commission, or any time you know the percentage and need to find the actual number.

Calculating Percentage Change Between Two Numbers

To find how much a number changed as a percentage, use =((new-old)/old)*100. If sales were 1000 last month and 1200 this month, the formula is =((1200-1000)/1000)*100, which gives 20. That means sales increased by 20%.

If the new number is smaller than the old number, the result is negative, showing a decrease. If last month was 1200 and this month is 1000, the formula gives -16.67, meaning a 16.67% drop.

Use cell references to make this dynamic: =((B2-A2)/A2)*100 where A2 is the old value and B2 is the new value. Format the result as a number with decimal places rather than percentage format, since the formula already multiplies by 100.

Common Mistakes and How to Fix Them

The most common error is forgetting to divide by the whole. If you write =45*200 instead of =45/200, you get 9000 instead of 22.5%. Double-check that you are dividing the part by the whole, not multiplying.

Another mistake is explore percentage formatting when you have already multiplied by 100 in the formula. If you write =(45/200)*100 and then format as percentage, Google Sheets multiplies by 100 again and shows 2250%. Write the division only, then format, or write the full formula and format as a number.

If your percentage shows as a decimal like 0.225 instead of 22.5%, the cell is formatted as a number instead of a percentage. Select the cell, click the % button in the toolbar, and it converts to the right display.

Using Percentages in Other Calculations

Once you have percentages in your spreadsheet, you can use them in other formulas. To find the average of several percentages, write =AVERAGE(C2:C10) where C2 through C10 hold your percentage values. Google Sheets treats them as decimals and calculates correctly.

To add a percentage increase to a number, use =number*(1+percentage). If you want to increase 500 by 20%, write =500*1.20 or =500*(1+0.20). To decrease by 20%, use =500*0.80 or =500*(1-0.20).

These formulas work with cell references too: =A2*(1+B2) increases the value in A2 by the percentage in B2. This is how you calculate sale prices, tax totals, or adjusted budgets.

Frequently Asked Questions

How do I show percentages with no decimal places?

Right-click the cell with the percentage, choose Format cells, and set decimal places to 0. Google Sheets rounds 22.5% to 23% and 22.4% to 22%. You can also select the cell and use the decrease decimal button in the toolbar (it looks like .0 with an arrow).

Can I calculate percentages across multiple sheets?

Yes. Reference another sheet by writing the sheet name followed by an exclamation point: =Sheet2!A2/Sheet2!B2. If the sheet name has spaces, put it in single quotes: ='Sales Data'!A2/B2. The formula works the same as referencing cells on the same sheet.

What if I want to show a percentage as a whole number like 22 instead of 22.5?

Use the ROUND function: =ROUND((A2/B2)*100,0). The 0 at the end tells Google Sheets to round to zero decimal places. You can also format the cell as a number with zero decimals instead of using ROUND.

How do I calculate what percentage one number is of another if the total is split across multiple cells?

Add the cells together in the formula. If parts are in A2 and A3, and the whole is in B2, write =(A2+A3)/B2 and format as percentage. You can also use SUM: =SUM(A2:A3)/B2.