6th October 2019

office
13

How do you do a subtraction formula in Excel?

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.

How do you subtract columns in Excel?

Subtract two or more numbers in a cell
  1. Click any blank cell, and then type an equal sign (=) to start a formula.
  2. After the equal sign, type a few numbers that are separated by a minus sign (-). For example, 50-10-5-3.
  3. Press RETURN . If you use the example numbers, the result is 32.

How do you subtract in Excel 2016?

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:
Write Your Answer

Rate

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

4.3 / 5 based on 3 votes.

Bookmark

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

Share