Subtracting numbers in Microsoft Excel may take a few more steps than you're used to, but it can be done. In this guide, we'll show you four different ways to subtract in Excel: Within a cell, using numbers from different cells, via the SUM function, and using the status bar. This way, you'll have a different method you can use depending on your subtraction needs or desired level of ease of use. Scroll on to learn how to subtract in Excel.
Difficulty Easy Duration 10 minutes What You Need Contents How to subtract within a cellJust need to quickly subtract two numbers? You can do that within a single cell in an Excel spreadsheet. Step 1: In an Excel spreadsheet, click on an empty cell. Then, within that cell, type the following :Step 2: Then hit Enter on your keyboard.
The correct answer to your subtraction math problem should immediately appear and replace the formula you typed in.How to subtract in different cellsIf you have numbers located in different cells in your spreadsheet that you want to subtract, you can do so by using cell references and a formula.
Then just select both cells. Now look at the bottom of the screen at the status bar. You'll find your answer next to SUM:.