Another example is SUM(A1, A3, A5) which adds the numbers that are contained in cells A1, A3, and A5 (A1, A3, and A5 are arguments). For example, SUM(A1:A5) adds all the numbers in the range of cells A1 through A5.

Each argument can be a range, a cell reference, an array, a constant, a formula, or the result from another function. The SUM function adds all the numbers that you specify as arguments. Method 1: Finding Differences Between Two Cells by Using Subtraction Formula in Excel. To switch between viewing the results and viewing the formulas, press CTRL+` (grave accent) on your keyboard.Or, click the Show Formulas button (on the Formulas tab). 8 Suitable Ways to Apply Subtraction Formula in Excel. In the worksheet, select cell A1, and then press CTRL+V. Subtracts 9000 from 15000 (which equals 6000)Īdds all number in the list, including negative numbers (net result is 16000) Select all of the rows in the table below, then press CTRL-C on your keyboard.

In this case, the formula you just created will always deduct whichever numbers are there in the second cell from the. Hit enter to subtract one cell from another. Start the formula by entering equal () and then select the first cell, put a minus (-), and then select the second cell. Exampleįollow these steps to subtract numbers in different ways: Excel formula for subtraction deducts one cell from another. Use the SUM function and convert any numbers that you want to subtract to their negative values. Note: There is no SUBTRACT function in Excel. It is a simple computation where we want to go back 30 hours in time from Decemmidnight.

Subtraction formula in excel