28th August 2018

9

# How do I subtract a percentage in Excel?

Tip: You can also multiply the column to subtract a percentage. To subtract 15%, add a negative sign in front of the percentage, and subtract the percentage from 1, using the formula =1-n%, in which n is the percentage. To subtract 15%, use =1-15% as the formula.

Simply so, how do you make a subtraction formula in Excel?

The important points to remember about Excel formulas include:
1. Formulas in Excel always begin with the equal sign ( = );
2. The formula is always typed into the cell where you want the answer to appear;
3. The subtraction sign in Excel is the dash ( - );
4. The formula is completed by pressing the Enter key on the keyboard.

How do you subtract one column from another in Excel?

Subtract numbers using cell references
1. Type a number in cells C1 and D1. For example, a 5 and a 3.
2. In cell E1, type an equal sign (=) to start the formula.
3. After the equal sign, type C1-D1.
4. Press RETURN . If you used the example numbers, the result is -2. Notes:

How can you subtract?

Method 5 Subtracting a Fraction from a Whole Number
1. Write down the problem.
2. Turn the whole number into a fraction with the same denominator as the fraction.
3. Rewrite the problem.
4. Subtract the numerators of the fractions while keeping the denominator the same.
5. Write your final answer.
##### Write Your Answer

###### Rate

80% people found this answer useful, click to cast your vote.

4 / 5 based on 3 votes.

##### Bookmark

Press Ctrl + D to add this site to your favorites!