Google Sheets: How to Find a Percentage of a Number

To find a percentage of a number in Google Sheets, multiply the number by the percentage: if the number is in A2 and the percentage is in B2, enter =A2*B2. Enter the rate as a percentage, such as 15%, and Sheets returns the requested portion of the number.

The basic percentage formula

A percentage means a quantity out of 100. For a calculation, Sheets treats 15% as the decimal value 0.15, so multiplying a number by 15% gives 15 percent of that number. For example, 15% of 240 is 36. You can enter the rate directly in the formula or keep it in a separate cell so it is easy to change.

With 240 in A2 and 15% in B2, enter this in C2:

=A2*B2

The result is 36. If A2 contains 80 and B2 contains 25%, the same formula returns 20. This is the usual setup for commissions, discounts, tax estimates, survey counts, and other calculations where a percentage rate applies to a value.

To use a fixed rate without a separate rate cell, keep the number in A2 and use a 15% rate:

=A2*15%

If A2 is 240, this returns 36. A cell reference is more flexible when the rate might change or when you need to apply the same rate to many values.

Enter the percentage the right way

In Google Sheets, you can type a percentage directly into a cell, including the percent sign. Typing 15% stores the equivalent decimal value, 0.15, while showing it as 15%. You can also type 0.15 and then format the cell as a percentage. Both approaches represent the same rate for multiplication.

Be careful if you enter 15 without a percent sign. Sheets treats that as the number fifteen, not fifteen percent. Multiplying 240 by 15 would give 3,600. If your rate is stored as the whole number 15 in B2, divide it by 100 in the calculation. With 240 in A2 and 15 in B2, use:

=A2*B2/100

This returns 36. For a clean, reusable worksheet, it is usually clearer to enter rates as percentages in the cells, such as 15%, rather than storing them as whole numbers and remembering to divide by 100.

Set up a sheet and fill the calculation down

A small table makes percentage calculations easier to review and update. Put each original number in one column, the percentage rate in another, and the result in a third. For example, column A might hold order amounts, column B the discount rate, and column C the discount amount. Label the columns so that the result is not confused with the original price or the price after discount.

Enter a number, such as 240, in A2.
Enter a rate, such as 15%, in B2.
Select C2, type =A2*B2, and press Enter.
Check that the result is 36, then copy or fill the formula down for other rows.

When you copy the formula down one row, Sheets adjusts the references automatically: the next row calculates using A3 and B3. This is called a relative reference. It is useful when each row has its own number and rate. To copy a formula, select the cell and drag its small blue fill handle down, or copy and paste it into the destination cells.

To find what percentage one value is of a total, divide the part by the total instead. With the part in B2 and the total in C2, use:

=B2/C2

If B2 is 18 and C2 is 60, the result is 0.3, which is the decimal equivalent of 30%. Format the result as a percentage to display 30%. This is a different question from finding 30% of 60: that calculation multiplies, while finding what share 18 is of 60 divides.

Use one rate for many numbers

If the same rate applies to every row, keep the rate in one cell rather than typing it repeatedly. For instance, place the rate 8% in B1 and the values in A2 through A5. If you enter a formula in C2 and fill it down, a normal reference to B1 would shift to B2, B3, and so on. Make the rate reference absolute with dollar signs so it remains fixed.

With values in A2:A5 and the shared rate in B1, put this formula in C2 and fill it down:

=A2*$B$1

The first row calculates A2 times the rate in B1; the next row calculates A3 times the same B1 rate. The dollar signs lock both the column and row of the rate cell. If the rate is in a different cell, change the reference accordingly. You can type the dollar signs into the formula directly.

This setup is handy for applying one tax rate, commission rate, or markup rate across a list. Changing B1 updates every result at once. It also makes assumptions visible: someone reviewing the sheet can see the rate separately instead of having to find a percentage embedded inside each formula.

Distinguish a percentage amount from a final total

Finding 15% of a price gives the percentage amount, not necessarily the final price. If an item costs 240 and receives a 15% discount, the discount amount is 36, but the discounted price is 204. Keep those outputs distinct in your table, especially if you need to report both the savings and the amount paid.

With the original price in A2 and the discount rate in B2, use this formula to calculate the discounted price:

=A2*(1-B2)

For 240 and 15%, the result is 204 because the formula multiplies the original amount by the remaining 85%. For an added percentage, such as a markup, multiply by one plus the rate instead. With the original amount in A2 and the markup rate in B2, use:

=A2*(1+B2)

If A2 is 240 and B2 is 15%, this returns 276. The percentage amount itself would still be 36. A common mistake is to use the percentage amount as if it were the final total, or to add or subtract the percentage as a whole number instead of as a proportion.

Find the original number or a percentage change

Sometimes you know the percentage amount and the rate, and want to recover the original number. This reverses the basic multiplication: divide the known portion by the percentage. With the portion in A2 and the rate in B2, enter:

=A2/B2

If A2 is 36 and B2 is 15%, the result is 240. This is not the same as adding 15% to 36; it asks what starting number would have 36 as its 15% portion.

Percentage change is another related calculation. It compares the difference between a new value and an old value with the old value. With the old value in A2 and the new value in B2, use:

=(B2-A2)/A2

If A2 is 120 and B2 is 150, the difference is 30, and 30 divided by 120 is 0.25. Format the result as a percentage to display a 25% increase. A negative result indicates a decrease. The order matters: switching the old and new values changes the meaning of the comparison.

Format the result and check what it displays

A calculation can be correct even when the displayed format is not what you expect. To show a decimal result as a percentage in Google Sheets in a web browser, select the cell or range and choose Format > Number > Percent. The toolbar also has a percentage-format button. For example, a result of 0.15 displays as 15% when formatted as a percentage.

Formatting changes how a value appears, not the underlying calculation. If a cell contains 15 and you apply percentage formatting, it displays as 1,500%, because 15 is fifteen times one, not 0.15. To represent 15%, enter 15% or 0.15. Likewise, if you want a result such as 36 to remain a plain amount, leave it formatted as a number or apply a suitable currency format rather than percentage formatting.

If you need more or fewer decimal places in a displayed percentage, use the decimal-place controls in the toolbar. Consider the purpose of the sheet: a rate might be shown as 15%, while a measured result may need 15.25%. Rounding the display does not necessarily round the value used in later calculations. If a task specifically requires rounded values, use a rounding formula or adjust the underlying values deliberately rather than relying only on the display.

Common errors and how to fix them

The result is 100 times too large: Check whether the rate was entered as 15 instead of 15%. Use a percentage value or divide a whole-number rate by 100.
The answer shows as a decimal: The calculation may be right. Apply percentage formatting if the question asks what percentage one value is of another.
The result looks like 1,500%: The cell likely contains 15 and is formatted as a percentage. Enter 15% or 0.15 for a 15% rate.
The formula changes the rate when filled down: Lock the rate reference with dollar signs, as in $B$1.
The result is zero or an error: Check that the input cells contain numbers rather than text, and confirm that the rate cell is not blank. A blank or text value can affect calculations unexpectedly.
A percentage-of-total result gives an error: Check whether the total is zero. Dividing by zero is undefined, so the total must be a nonzero number.

For a quick check, calculate a small example by hand. If the question is 10% of 50, the answer must be 5. If the sheet returns 500, the rate was probably entered as 10 instead of 10%. This simple check often reveals a scale or formatting issue before it spreads through a larger table.

Frequently Asked Questions

What is the formula for finding a percentage of a number in Google Sheets?

Multiply the number by the percentage. If the number is in A2 and the rate is in B2 as a percentage, use =A2*B2. For example, 15% of 240 is 36.

How do I calculate 20% of a number?

If the number is in A2, enter =A2*20%. If A2 contains 150, the result is 30. You can also put 20% in another cell and multiply by that cell.

How do I find what percentage one number is of another?

Divide the part by the total, then format the result as a percentage. If the part is in B2 and the total is in C2, use =B2/C2. A part of 18 out of 60 gives 30%.

Why does Google Sheets show 1,500% instead of 15%?

The cell probably contains the number 15 and has percentage formatting. Percentage formatting interprets 1 as 100%, so 15 appears as 1,500%. Enter 15% or 0.15 to represent a 15% rate.

Can I use the same formula in Excel?

Yes. The basic multiplication formula works in both Google Sheets and Excel. The formula examples here use Google Sheets in a web browser; menu names and the interface for formatting can differ in Excel.

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.