Return to site

What is the formula for subtraction in excel

broken image

Along with it the reference cell is automatically placed in the formula. Select the cell you want to be subtrahend it is the number subtracted.

broken image

Select the cell you want to be minuend it is the number where the other number is to be subtracted. To start your formula type the equal sign(=) where you want to see the result of subtraction. Here is how to subtract in Excel follow these steps to create yours: The first thing you should remember in creating a formula is to put an equal sign to start the formula.įor instance, to subtract numbers of a cell from another cell use this syntax: =A2-B2

broken image
broken image

In subtraction, you will use the minus sign (-) formula but you will use cell references instead of actual numbers.

broken image