How to Subtract a Percentage in Excel

To subtract a percentage from a number in Excel, multiply the number by 1 minus the percentage. With a price in A2 and a discount rate in B2, type =A2*(1-B2) in an empty cell and press Enter. Taking 20% off 50 returns 40. These steps apply to Excel for Microsoft 365 and Excel 2024, 2021, 2019 and 2016 on Windows, plus Excel for Microsoft 365, 2024 and 2021 on a Mac.

What You Need to Know First

Excel stores a percentage as a decimal. A cell that shows 15% actually holds 0.15, and the percent sign is only the cell’s number format. That matters because 1-B2 only gives you the remaining share (85%) when B2 holds 0.15. If B2 holds the plain number 15, the same formula calculates 1 minus 15 and returns a large negative result.

Two terms come up below. The fill handle is the small square at the bottom-right corner of a selected cell; dragging it copies a formula to neighboring cells. An absolute reference such as $E$1 uses dollar signs so the cell address stays fixed when you copy the formula. If basic cell subtraction is new to you, start with the basics of subtracting in Excel and come back here.

Subtract a Percentage With a Formula

This method keeps your original numbers and updates the result automatically whenever the price or the rate changes. It matches the approach in the Microsoft support page on multiplying by a percentage.

  1. Type your starting amounts in column A, beginning in A2 (put a header such as “Price” in A1).
  2. Type each percentage in column B with the percent sign, for example 20%. Excel stores that as 0.2.
  3. Click C2 and type =A2*(1-B2).
  4. Press Enter (Return on a Mac). C2 shows the amount left after the percentage is removed.
  5. Select C2 again and drag the fill handle down to the last row of data. Each row now uses its own price and its own rate.

If you would rather see the logic spelled out, =A2-(A2*B2) gives the same answer: it works out the discount amount and subtracts it. To show only the amount removed, use =A2*B2. For a quick one-off answer without any cells, type the numbers directly, such as =113*(1-0.25), which returns 84.75.

Use One Rate for a Whole Column

When every row gets the same discount, store the rate once and lock it. Put 15% in E1, then type =A2*(1-$E$1) in C2 and fill down. On Windows, you can click the E1 reference in the formula bar and press F4 to add the dollar signs; on a Mac, typing them works fine. Change E1 to 10% later and every result in column C recalculates.

Reduce Values in Place With Paste Special

Paste Special changes the original numbers directly, with no helper column. The results are fixed values, so they will not update if you change the rate later. Pick this method for a one-time price cut; pick the formula when you need a live link. Warning: this overwrites the selected cells, so copy the column somewhere else first if you might need the old figures.

On Windows

  1. In an empty cell, type the share you want to keep. To remove 15%, type =1-15% (or simply 85%).
  2. Select that cell and press Ctrl+C.
  3. Select the numbers you want to reduce.
  4. Right-click the selection and choose Paste Special, or press Ctrl+Alt+V.
  5. Under Paste, choose Values. Under Operation, choose Multiply.
  6. Click OK. Each selected number is now 15% lower, and you can delete the helper cell.

On a Mac

  1. Type 85% in an empty cell and copy it with Command+C.
  2. Select the numbers you want to reduce.
  3. On the Home tab, click the arrow next to Paste and choose Paste Special.
  4. Select Values and Multiply, then click OK.

Don’t be tempted by the Subtract operation in that dialog. It subtracts the copied value itself, so copying 15% and choosing Subtract takes 0.15 off each number instead of 15 percent of it.

Subtracting One Percentage From Another

Sometimes both cells are already percentages, such as a profit margin that dropped from 35% to 30%. Plain subtraction handles that: =A2-B2 returns 5%, a drop of five percentage points. Applying the same steps you would use to subtract one column from another works here, too.

That is a different question from shrinking a rate by a percentage. Cutting a 40% return rate by 10% of itself uses =A2*(1-B2) and gives 36%, not 30%. Decide which one you mean before you write the formula.

Worked Example: Three Discounted Orders

Here is a small fictional order sheet. Prices are in column B, discounts in column C, the formula =B2*(1-C2) is in D2 and filled down, and =B2*C2 in column E shows the savings.

Customer (A)Price (B)Discount (C)Final price (D)Savings (E)
Alex$80.0015%$68.00$12.00
Jordan$120.0025%$90.00$30.00
Priya$45.0010%$40.50$4.50

Now suppose Jordan’s $120 order also qualifies for an extra 10% loyalty discount on top of the 25%. Discounts in a row do not add up to 35%. Each one applies to what is left, so multiply the factors: =B3*(1-C3)*(1-10%) returns $81.00, while a flat 35% would give $78.00.

When the Answer Looks Wrong

Most problems come from how the rate was typed, missing parentheses, or the result cell’s format.

  • Huge negative number: the rate cell holds 15 rather than 15%. Retype it as 15% or 0.15, or divide inside the formula with =A2*(1-B2/100).
  • Rate shows as 1500%: applying the Percentage format to a cell that already contains 15 multiplies it by 100. Format empty cells first, or enter the rate as a decimal. The percentage formatting rules explain how Excel treats numbers typed before and after the format is applied.
  • Result barely changed: the parentheses are missing. Excel multiplies before it subtracts, so =A2*1-B2 with 80 and 15% returns 79.85 instead of 68. Keep (1-B2) in parentheses.
  • Typing =45-10% gives 44.9: Excel reads 10% as 0.1 and subtracts it from 45. Use =45*(1-10%) to get 40.5.
  • Final price shows as a percentage: the result cell picked up percent formatting. Select it and choose Currency, Accounting or General from the Number Format box on the Home tab.
  • Every row uses the wrong rate after filling down: a shared rate cell needs dollar signs, as in $E$1, or the reference shifts one row with each copy.

Check the Result and Undo Mistakes

To confirm a result, add the final price and the savings back together; they should equal the original amount. In the example, $68.00 plus $12.00 returns Alex’s $80.00. You can also divide the final price by the original: =D2/B2 should show 85% for a 15% discount once the cell uses the Percentage format (Ctrl+Shift+% on Windows, or the Percent Style button in the Number group on the Home tab).

If Paste Special reduced the wrong cells, press Ctrl+Z (Command+Z on a Mac) right away to restore the original values. Formula results are easier to fix: correct the formula in the first cell and fill it down again. To freeze formula results as plain numbers, copy them and use Paste Special with Values and the Operation set to None.

Other Questions About Percentages in Excel

How do I add a percentage instead?

Change the minus sign to a plus sign. =A2*(1+B2) adds the rate, which suits sales tax or a price increase. For example, =113*(1+0.25) returns 141.25.

How do I find the percentage a value dropped?

Subtract the old value from the new one and divide by the old value: =(B2-A2)/A2. With 2,500 falling to 2,425, the result is -0.03, which shows as -3.00% in Percentage format. The negative sign marks a decrease.

Can I subtract a percentage across many columns at once?

Yes. Paste Special with Multiply works on any rectangular selection, not just one column. With formulas, lock the rate cell with $E$1 and fill both right and down. For combining several cells into one result first, see subtracting multiple cells in Excel.

Does the same formula work in Google Sheets?

The =A2*(1-B2) formula works the same way there, since Sheets also treats 15% as 0.15. The menus differ, so check how subtraction works in Google Sheets for the interface details.

Next, put your rate in its own cell and build the formula around it. That way a single edit updates every price in the sheet, and the original numbers stay untouched.

Matthew Burleigh

Matthew Burleigh has been writing technology tutorials online since 2008. He holds Bachelor's and Master's degrees in Computer Science from Arizona State University and has worked in IT since 2003, from small-business IT support to IT management and consulting.