Excel Formula for Subtraction

Excel formulas for subtraction are similar to those of addition but with the minus sign.

Let us go through the steps for subtracting 15 from 25. Enter values in row 50 as follows:

Cell A50: 25

Cell B50: 15

Write the formula in cell C50 as follows:

=A50-B50

To write this formula, click cell C50, where you want the result. Enter “=”. Click on cell with value 25 (reference:A50). Enter “-“(minus sign). Click on cell with value 15 (reference B50). Press enter key.

If you enter 15 first and 25 later, then the question will be to find result of subtraction 15-25.

Previous

TOC

Next