Using Microsoft Excel to subtract numbers 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.
Just 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 (omit the brackets and spaces):
=[first number] - [second number]
For our example, that would look like: =9-1
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.
In our example, the answer that appeared was 8.
If 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.
Step 1: Choose the numbers you want to subtract and make note of their respective cell references. (A cell reference is a way to denote the location of a given cell in a spreadsheet and the combination of a cell's column number and row number. For example, if one of your numbers is in a cell that is located in column A and row 6, the cell reference for that number would be A6.)
Step 2: Click on a blank cell in your spreadsheet and type in the following formula, omitting the spaces and brackets and filling in your numbers' cell references where appropriate:
=[cell reference for first number] - [cell reference for second number]
In our example, that would look like: =A5-A6
Step 3: Then hit Enter on your keyboard.
The correct answer to this subtraction problem should automatically appear in place of the formula you just typed in.
For our example, since A5 equals 444 and A6 equals 227, the answer that appeared was 217.
(You can protect the formulas and the data they rely on by locking specific cells of the spreadsheet.)
While Excel doesn't have a separate subtract function, you can still use the SUM function to subtract numbers.
Step 1: Click on an empty cell. Then type in the following (entering in your own numbers):
=SUM(first number,-second number)
Note: It doesn't matter which number is the negative one, but one of them has to be for the subtraction to occur.
So in our example, since we want to subtract 227 from 444 the formula can look like this:
Step 2: Hit Enter on your keyboard.
The correct answer should immediately replace the formula you typed in.
In our example, the answer would be 217.
You don't always have to enter in a formula to subtract numbers in Excel. You can also just use Excel's status bar (located at the bottom of your screen) to your advantage. Just type your numbers into their own individual cells and turn one of them into a negative number. So again, if you wanted to subtract 227 from 444, you would type 444 into one cell and type -227 into the cell next to 444.
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:.
Creating formulas to subtract values in Excel is straightforward to start with, but as you can see it has some advanced uses. Getting to grips with basic math in spreadsheets can help you make the most of this software. So, why not spend some time learning how to multiply in Microsoft Excel?
Once you've done that, make sure you're familiar with Excel's keyboard shortcuts, which will help you to become more adept at using the software.
The absolutely absurd idea of putting a touchscreen display on a mouse isn't exactly new. Turtle Beach already did it with its Command Series MC7, which features a 2.25-inch control screen. But apparently, even that wasn't ridiculous enough for Arctic Fox Technologies. Its new Super Mouse looks like someone took the chunky old Atari ST mouse, slapped a touchscreen and scroll wheel on it, and called it an upgrade.
The result is a rather unusual-looking mouse that is now on Kickstarter, starting at $199. And as ridiculous as it looks, some of its features are genuinely intriguing.
Apple is less than a day away from launching its highly anticipated OLED MacBook Pro with a touch-sensitive screen. But it appears that the upgrade is going to cost a pretty penny. According to a report by Bloomberg, Apple is reportedly eyeing a starting price of $2,899 for the 14-inch MacBook Pro, while the 16-inch version could start at $3,399 in the US.
"At $2,899, the 14-inch model would mark the highest starting price for a new MacBook Pro model, surpassing the $2,799 Apple charged for a 17-inch version introduced in 2006," says the report. The report claims that Apple is targeting a minimum price hike of $400 for its upcoming redesigned 14-inch and 16-inch MacBook Pro models.
I've spent a good amount of time digging into the spec sheet of the new M6 MacBook Pro (14-inch), and for all intents and purposes, this is a classic Apple "chip and connectivity" refresh. It's not a full redesign. The chassis, Liquid Retina XDR panel, speakers, ports, and battery, all of them carry over unchanged.
However, the M6 brings more cores, stronger on-device AI, higher memory bandwidth on the larger configs, and modern wireless. Here’s the practical rundown of what actually improved, and whether those gains are worth your money.