Google Sheets: How to Multiply by a Percentage

How-to basics · Updated November 21, 2026

Yes. In Google Sheets, multiply a value by a percentage with =A2*B2 when the number is in A2 and the percentage is in B2. For example, if A2 contains 80 and B2 contains 15%, the result is 12. The same method works for prices, quantities, budgets, discounts, and other calculations.

The basic percentage multiplication formula

A percentage is a number expressed as a fraction of 100. Google Sheets stores 15% as the numeric value 0.15, so multiplying 80 by 15% is the same as multiplying 80 by 0.15. The product, 12, is 15% of 80. You do not need a special percentage function: the ordinary multiplication operator, an asterisk, does the job.

With the amount in A2 and a percentage entered in B2, use =A2*B2. If A2 is 80 and B2 is 15%, the formula returns 12. You can also type the percentage directly into a formula. With 80 as the amount and a 15% rate, =80*15% returns 12. Cell references are usually more convenient because you can change the inputs without editing the formula.

To enter a formula, select the cell where you want the result, type an equals sign followed by the calculation, and press Enter. In Google Sheets in a web browser, you can enter the formula in the cell or in the formula bar. The result appears in the selected cell, while the formula remains available to inspect or edit.

Enter and format the percentage

You can enter a percentage by typing a number followed by the percent sign, such as 15%, in a cell. You can also type 0.15 and format the cell as a percentage. These entries represent the same numeric rate. By contrast, typing 15 without a percent sign means the value is fifteen, not fifteen percent; multiplying by that cell would produce a result 100 times larger than intended.

To format a cell as a percentage, select the cell or range and choose Format > Number > Percent. The toolbar also has a percentage formatting button. Formatting changes how a number is displayed; it does not replace the underlying value. For instance, formatting 0.15 as a percentage displays 15%, while formatting 15 as a percentage displays 1,500%.

Choose the displayed precision to suit the calculation. A rate such as 12.5% may need one decimal place, while a whole-number rate such as 15% may be clearer with none. Percentage formatting is especially useful when other people will inspect the sheet, because it makes the rate easier to recognize and reduces confusion about whether a cell contains 0.15 or 15.

Calculate a percentage, an increase, or a discount

Multiplying a value by a percentage gives the percentage amount, not the original value plus or minus that amount. This distinction matters when working with a price increase or discount. Use the calculation that matches the result you want:

  • Find a percentage of a value: multiply the value by the rate. With 80 in A2 and 15% in B2, =A2*B2 returns 12.
  • Add a percentage increase: multiply the original value by one plus the rate. With an original price of 80 in A2 and an increase rate of 15% in B2, =A2*(1+B2) returns 92.
  • Subtract a percentage discount: multiply the original value by one minus the rate. With an original price of 80 in A2 and a discount rate of 15% in B2, =A2*(1-B2) returns 68.

The examples use the same starting value and rate, but answer different questions. The first calculates the amount of the increase or discount: 12. The second calculates the increased total: 92. The third calculates the discounted total: 68. For a bill or quote, be clear about whether you need the percentage amount as a separate line or the final adjusted total.

A related point: adding 15% and then subtracting 15% does not restore the original amount. A 15% increase on 80 gives 92; a 15% discount from 92 is 13.80, leaving 78.20. The second percentage is calculated from the new base, 92, rather than the original 80.

Apply the calculation to a column

For a list of transactions, put each amount in one column and its percentage in another. For example, amounts can go in A2:A6, rates in B2:B6, and results in C2:C6. With the amount in A2 and the matching rate in B2, enter =A2*B2 in C2. The formula returns the percentage amount for the first row.

To calculate the other rows, select C2 and drag the small square at the lower-right corner of the selection down through the remaining rows. You can also copy C2 and paste it into the cells below. Google Sheets adjusts relative references as it fills: the next row will refer to A3 and B3, then A4 and B4. Check the first and last filled rows to make sure each amount is paired with the intended rate.

If the table is still being built, filling the formula only through the rows that contain data keeps the sheet tidy. A blank output row may appear as zero or remain visually empty depending on the formula and cell contents, so avoid interpreting every displayed zero as a meaningful percentage result. If you need a formula that suppresses output for empty input rows, first decide which blank-input behavior is appropriate for the sheet.

Use one percentage for many values

Sometimes every amount uses the same rate, such as a standard commission or an illustrative tax calculation. Put that rate in one cell, then lock its reference before filling the formula down. This keeps the rate in place while the amount reference changes from row to row.

For example, suppose amounts are in A2:A6 and the shared rate is in B1. With the amount in A2 and the fixed rate in B1, enter =A2*$B$1 in C2. If A2 is 80 and B1 is 15%, the result is 12. Fill the formula downward: the amount reference becomes A3, A4, and so on, while the absolute reference stays at B1.

The dollar signs in $B$1 lock both the column and row when the formula is copied. A reference such as B$1 locks only the row, while $B1 locks only the column. For a single rate stored in one cell, locking both is the most straightforward choice. This is a reference behavior, not a special percentage feature.

Common errors and how to fix them

  • The result is 100 times too large: check whether the rate cell contains 15 rather than 15%. If the intended rate is fifteen percent, enter 15% or enter 0.15 and apply percentage formatting.
  • The result is zero: confirm that the input cells contain numeric values rather than text that only looks like a number. Re-entering the amount or rate, or changing the cell format and entering it again, can resolve a text-entry issue.
  • The formula displays as text: make sure it begins with an equals sign and that the cell is not being treated as plain text. Change the cell format to Automatic if needed, then re-enter the formula.
  • The copied results all use the same amount: check whether the amount reference was accidentally locked with dollar signs. For a row-by-row calculation, the amount reference normally needs to move as the formula is filled down.
  • The rate changes when copied but should stay fixed: use an absolute reference for the shared rate, such as $B$1, rather than a relative reference.

Also distinguish rounding from display formatting. A cell may show 12.35 because it is formatted to two decimal places while holding additional decimal places underneath. Changing the number of displayed decimals does not necessarily change the value used in later calculations. If a business process requires rounding the calculated amount itself, establish the required rounding rule rather than assuming the display setting has changed the math.

Display results clearly and check the arithmetic

The product of a currency amount and a percentage is often another currency amount. If 80 dollars is multiplied by 15%, the numeric result is 12. Format the result as currency when that makes the sheet easier to read: select the output cells and choose Format > Number > Currency. A currency format affects display, not the multiplication itself. Use a percentage format for rate cells and a suitable number or currency format for calculated amounts.

For a quick manual check, convert the rate to a decimal and multiply. Fifteen percent is 0.15, and 80 multiplied by 0.15 is 12. For a discount, subtract that amount from the original: 80 minus 12 is 68. These simple checks can reveal a misplaced cell reference, an incorrectly entered rate, or a formula that calculates the percentage amount when you intended the final total.

Google Sheets compared with Excel

The basic multiplication method is the same in Google Sheets and Microsoft Excel: use the asterisk operator, percentage values, and cell references. The examples here are for Google Sheets in a web browser. In Sheets, use its Format > Number menu for number formatting; Excel has its own ribbon and menu layout, even though the arithmetic is equivalent. A spreadsheet copied between the two applications can generally retain this kind of simple formula, but check formatting and cell references after transferring a larger workbook.

In either program, the calculation depends on the stored values, not the application’s appearance. A cell displaying 15% represents 0.15 in the calculation. If a sheet is shared with collaborators, clear column headings such as Amount, Rate, and Percentage amount help communicate how each result was calculated.

Frequently Asked Questions

How do I multiply a price by 20% in Google Sheets?
Enter 20% in a rate cell and multiply the price cell by that rate. For a price in A2 and a rate in B2, use =A2*B2. This returns the 20% amount; to calculate the price after a 20% increase, use a one-plus-rate calculation instead.

How do I add 10% to a number in Google Sheets?
Multiply the original number by one plus the 10% rate. With the original number in A2 and 10% in B2, use =A2*(1+B2). If A2 is 50, the result is 55.

How do I take 10% off a price?
Multiply the original price by one minus the discount rate. With a price in A2 and 10% in B2, use =A2*(1-B2). For a price of 50, the discounted total is 45.

Can I type 0.2 instead of 20%?
Yes. The numeric value 0.2 is equivalent to 20%, so it gives the same multiplication result. Format the cell as a percentage if you want Sheets to display 20% rather than 0.2.

Why does multiplying by 15 return a much bigger result than expected?
A cell containing 15 is the number fifteen, not fifteen percent. Enter 15% or 0.15 for a fifteen-percent rate. Formatting 15 as a percentage would display 1,500%, which is a clue that the stored value is not the intended rate.

Related

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.