Using Microsoft Excelto 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 cubicle , using phone number from unlike cells , via the SUM office , and using the status bar . This way of life , you ’ll have a different method acting you’re able to habituate depending on your subtraction want or desire level of ease of use . whorl on to learn how to subtract in Excel .
How to subtract within a cell
Just need to rapidly subtract two routine ? you’re able to do that within a single cellphone in an Excel spreadsheet .
footmark 1 : In an Excel spreadsheet , snap on an empty cell . Then , within that mobile phone , type the following ( omit the brackets and spaces ):
=[ first number]-[second number ]
For our good example , that would look like : = 9 - 1
Step 2 : Then hitEnteron your keyboard .
The right answer to your subtraction math trouble should immediately come out and replace the formula you type in .
In our example , the result that appeared was 8 .
How to subtract in different cells
If you have numbers game located in different cell in your spreadsheet that you want to take off , you may do so by using cubicle references and a formula .
gradation 1 : pick out the numbers you need to subtract and make notation of their respective prison cell references . ( A cell reference is a way to denote the emplacement of a given cell in a spreadsheet and the combination of a cell ’s column identification number and row bit . For instance , if one of your numbers is in a prison cell that is located in column A and words 6 , the cellphone reference work for that number would be A6 . )
Step 2 : tap a vacuous cell in your spreadsheet and type in the following recipe , overleap the spaces and wall bracket and filling in your number ' cell references where appropriate :
=[ cell reference for first number]-[cell reference for 2nd number ]
In our case , that would look like : = A5 - A6
footfall 3 : Then hitEnteron your keyboard .
The correct answer to this subtraction job should automatically come along in place of the formula you just typecast in .
For our model , since A5 match 444 and A6 equate 227 , the resolution that appeared was 217 .
( you could protect the formulas and the data point they rely on bylocking specific electric cell of the spreadsheet . )
How to subtract using the SUM function
While Excel does n’t have a separate subtract procedure , you’re able to still use the SUM purpose to subtract numbers racket .
Step 1 : snap on an empty cell . Then typecast in the following ( entering in your own numbers ):
= SUM(first number,-second act )
observe : It does n’t matter which number is the negative one , but one of them has to be for the subtraction to come .
So in our example , since we require to subtract 227 from 444 the pattern can look like this :
= SUM(444,-227 )
or it can look like this
= SUM(-227 , 444 )
Step 2 : HitEnteron your keyboard .
The correct result should immediately replace the normal you typed in .
In our lesson , the answer would be 217 .
How to subtract using the status bar
You do n’t always have to enter in a chemical formula to take off numbers in Excel . you could also just use Excel ’s status legal profession ( located at the bottom of your screen ) to your reward . Just type your number into their own individual cells and reverse one of them into a minus number . So again , if you wanted to subtract 227 from 444 , you would type 444 into one cell and type -227 into the cubicle next to 444 .
Then just select both cell . Now appear at the bottom of the screen at the position streak . You ’ll recover your answer next toSUM : .
create formulas to subtract values in Excel is aboveboard to start up with , but as you’re able to see it has some advance uses . Getting to traction with introductory maths in spreadsheet can facilitate you make the most of this software . So , why not spend some fourth dimension learninghow to multiply in Microsoft Excel ?
Once you ’ve done that , make trusted you ’re conversant withExcel ’s keyboard shortcuts , which will help you to become more adept at using the computer software .
