answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

7y ago

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.
This answer is:
User Avatar

User Avatar

Wiki User

14y ago

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

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

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".

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

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

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

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

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

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

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

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]

This answer is:
User Avatar

User Avatar

Wiki User

10y ago

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

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the formula for subtraction in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is it true that Excel completes addition and subtraction?

Excel can do any kind of mathematical operation, so that includes addition and subtraction.


Formula to calculate in Excel?

In Excel, you can use formulas to perform calculations. For example, to add cells A1 and B1, you can write the formula "=A1+B1" in a different cell. Similarly, you can use formulas for subtraction, multiplication, and division by replacing the "+" operator with "-" for subtraction, "*" for multiplication, and "/" for division, respectively.


Is - a symbol for a mathematical operation in excel?

Yes, it is used for subtraction.


Order followed in excel that starts with negations and ends with subtraction?

oreder of opertaiotn


What are symbols that display mathematical operations such as addition or subtraction in Excel?

The plus sign does adding and the minus sign does subtraction in Excel: =A10+B2 =A2-50 The * is used for multiplication. The / is used for division: =A2*A3 =A6/40


What do you have to put in a cell to denote an equation in Excel?

In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.


When Excel follows the order of operations the formula 8 2 plus 5 equals?

The order of operations is BODMAS; Brackets; Other; Division; Multiplication; Addition; Subtraction. Therefore for the calculation 8*2+5, excel will do 8x2 first, then add five, yielding 21


Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.


What is the formula for PVIFA in Excel?

The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.


What is replicating a formula in Excel?

Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.


Is the order of subtraction in the slope formula important?

Yes


Where Excel displays the formula that is in a cell IS WHAT?

The formula bar.