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:**

- Formulas in Excel always begin with the equal sign ( = );
- The formula is always typed into the cell where you want the answer to appear;
- The subtraction sign in Excel is the dash ( - );
- 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**

- Type a number in cells C1 and D1. For example, a 5 and a 3.
- In cell E1, type an equal sign (=) to start the formula.
- After the equal sign, type C1-D1.
- 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**

- Write down the problem.
- Turn the whole number into a fraction with the same denominator as the fraction.
- Rewrite the problem.
- Subtract the numerators of the fractions while keeping the denominator the same.
- Write your final answer.