What is the formula for subtraction in Excel?

Answer 1

Here are two possibilities:

Direct subtraction (use Excel as a calculator). Enter this formula in a cell =8-6

Cell reference: Put 8 in cell A1 and 6 in cell A2, then enter =A1-A2 in cell A3.

Answer 2

If you want to subtract 6 from 12, enter the formula =12-6. To make a subtraction calculator, do the following:

• In cell A1, enter 12.
• In cell A2 enter 6.
• In cell A3, enter =A1-A2.

Answer 3

You use the minus sign. All formulas begin with an equals and most values are entered in cells, which can then be used in formulas. So if you want to subtract the value in cell A3 from the value in cell A1, then in a cell other than A1 or A3 you would put:

=A1-A3

Answer 4

You have to use cell reference to create a subtraction formula in excel. For example if you want to subtract two numbers in cell A1 and A2 then the formula should be like this "=A1-A2 or =A2-A1".

Answer 5

You use the minus sign. All formulas must begin with the equals sign. So your formulas, which can inlcude numbers and cell references can look like any of these ones:

=10-4

=A3-B6

=230-C10

=D14-127

Answer 6

To do subtraction in Excel you use the minus character. You can click on the cell you want the formula in, and then you can type it like:

=C10-D4

This will subract the amount in D4 from the amount in C10.

You can use a cell and a value, like this:

=C35-10

or

=200-A5

Answer 7

For doing subtraction in Excel, you would not need to use a function. A simple formula would do. Suppose you want to subtract a value in A3 from a value in A2, then you would use the following formula:

= A2 - A3

Answer 8

If you want to subtract the contents of two cells, use a formula like this in another cell:

=A1-A2

[Subtracts the contents of cell A2 from the contents of cell A1.]

EXAMPLE:

In A1, enter 12

In A2, enter 8

In A3, enter =A1-A2 [12-8 = 4]

Answer 9

There is no specific function in Excel for subtraction, like SUM for addition. We use the minus sign instead.