How To Minus Percentage In Excel

Subtracting a percentage in Excel is a useful skill when calculating discounts, reducing values, or adjusting totals. Excel makes it easy to perform these calculations using simple formulas. Whether you’re subtracting a fixed percentage or one stored in another cell, here’s how to minus percentage in Excel.

1. Enter Your Values

Start by entering your original values in one column. For example, type a number like 100 into cell A1, which will represent the original amount. In another cell, such as B1, you can type the percentage you want to subtract—for example, 10%.

If you don’t want to type the percentage in a separate cell, you can write it directly in the formula.

2. Subtract a Fixed Percentage

To subtract a fixed percentage from a number in Excel, use this formula:

= A1 – (A1 * 10%)

This formula means: subtract 10% of the value in A1 from the original number. The result will be 90 if A1 is 100.

Alternatively, you can use:

= A1 * (1 – 10%)

This gives the same result. It multiplies the original value by 90%, which effectively subtracts 10%.

3. Subtract a Percentage in Another Cell

If your percentage is written in another cell (say B1), then the formula becomes:

= A1 – (A1 * B1)

Or:

= A1 * (1 – B1)

So if A1 is 200 and B1 is 25%, the result will be 150.

Make sure the percentage in B1 is either typed as 25% or 0.25—Excel will understand both.

4. Apply the Formula to a List

If you have a column of values and you want to subtract the same percentage from all of them, write the formula for the first row (e.g., =A2 * (1 – 10%)), then drag the fill handle down the column to apply the formula to the rest.

If you’re using a percentage stored in another cell, use an absolute reference like this:

swift

= A2 * (1 – $B$1)

The dollar signs make sure that as you drag the formula down, the percentage in B1 stays constant.

5. Format the Results (Optional)

After subtracting the percentage, you can format the result as a number, currency, or any other format you prefer. Just select the cells with the results, right-click, choose “Format Cells,” and pick your desired style.

Also Read: How To Make Sugar