112. Subtracting numbers in Excel

Subtracting Numbers in Excel

Subtracting numbers in Excel is straightforward and involves using the subtraction operator (`-`). Follow the steps below to learn how to subtract numbers:

  1. Open Excel: Launch Excel and open a blank workbook or an existing sheet.
  2. Enter Numbers: Type the numbers you want to subtract into separate cells. For example, type `20` in cell A1 and `10` in cell B1.
  3. Select the Result Cell: Click on the cell where you want the result to appear, such as C1.
  4. Use the Formula: In the formula bar (or directly in the cell), type:
    =A1 - B1
    Press Enter, and Excel will display the result (e.g., `10` in this case).
  5. Update as Needed: If you change the values in cells A1 or B1, Excel will automatically recalculate the result.

Now, use the interactive example below to simulate subtraction in Excel.

Value 1 Value 2 Result
20 10 Click Calculate

Edit the values in the table above and click "Calculate Subtraction" to see the result.

Comments