Subtraction in Excel: There is no SUBTRACT function in Excel. using a minus (-) Arithmetic Operator sign, we can subtract any two values in excel.
We all know from primary schools that to subtract one number from another number we should use a minus sign.
In the previous Excel Addition Tutorial, we have already discussed how to use Arithmetic Operator sign to do addition.
In the same way, we can apply a minus sign to do subtraction in Excel. in Excel, you use cell references to subtract numbers instead of giving actual numbers.
Syntax: =(Value1-Value2) Or=Value1-Value2
Subtraction Formula used in the below example is=B5-C5.
In this above Subtraction example, we need to find the material-wise difference amount, for this, we need to subtract the Received Amount from Total Amount with help of minus (-) Arithmetic Operator sign. here we have subtracted B5 cell value C5 cell value.
In this example, using minus (-) sign we have subtracted four values in a single cell A1.
If you want to subtract multiple cell ranges using a minus sign, it will take more time to subtract individually. but with the help of SUM function, it is easy to subtract multiple ranges of cells in Excel.
In this above Subtraction example, we have a list of Products and Total Amount in cell B1. now we need to find a Balance Amount in cell B7 after subtracting the values of products.
To get the Balance Amount, we need to subtract the total SUM of the products from the Total Amount.
Using Absolute reference you can subtract numbers in the range of cells. in the below screenshot the Total Amount value is in the cell B2.
Using the Absolute reference ($) symbol , it is easy to find the difference amount of each product. it means for every product subtraction Total Amount is the Same. that means cell B2 value is fixed or frozen.
Before starting any Formula or Function in Excel you need to add (=). to subtract the number in a cell you will need to write a formula in the designated cells.
After watching the video you can download below sample sheet. and it helps you to do practice more. Please subscribe for more videos on our youtube channel. if you like our tutorial please share it on Facebook and Youtube below.
* To Learn Tutorials in a simple Way.
* To Learn Excel basics with downloadable samples.
* To Learn HTML with sample Website code.
* To Learn PowerPoint presentations.
* To Learn MS Word for offical use.