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.
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
In subtraction, you will use the minus sign (-) formula but you will use cell references instead of actual numbers.