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.
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:
- Type a minus sign ( - ) following the cell reference A1; Click on cell B3 with the mouse pointer to add that cell reference to the formula after the minus sign; Press the Enter key on the keyboard. The answer 10 should be present in cell C3.
- 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.
- Note: There is no SUBTRACT function in Excel. Use the SUM function and convert any numbers that you want to subtract to their negative values. For example, SUM(100,-32,15,-6) returns 77.
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.
- Part 1 Dividing
- Set up the equation. On a piece of paper, write the dividend (number being divided) on the right, under the division symbol, and the divisor (number doing the division) to the left on the outside.
- Divide the first digit.
- Divide the first two digits.
- Enter the first digit of the quotient.
- The first value is the minuend. The second value (the one you are subtracting) is called the subtrahend. The answer in a subtraction problem is called the difference.
- First write the number you want to subtract from then underneath the number you are subtracting. Start with the "ones" (least significant number) subtract the top from the bottom, this subtraction should be simple enough to do in your head if not use one of the above methods.
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.
- To calculate the percentage increase:
- First: work out the difference (increase) between the two numbers you are comparing.
- Increase = New Number - Original Number.
- Then: divide the increase by the original number and multiply the answer by 100.
- % increase = Increase ÷ Original Number × 100.
- ROUNDUP behaves like ROUND, except that it always rounds a number up.
- If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
- If num_digits is 0, then number is rounded up to the nearest integer.
- To calculate the percentage of the whole number, you need to first turn the percentage into a decimal as already described. Then simply multiply. For example, completing the problem of finding 15% of 100, rewrite the 15% as 0.15. Then just multiply 0.15 x 100, to get the solution of 15.
Updated: 2nd October 2018