- Excel Tutorial
- Excel Introduction
- Excel Addition(+)
- Excel Subtraction(-)
- Multiplication(*)
- Excel Division(/)
- Excel IF Function
- Excel SUMIF
- Count & CountIF
- Excel IFerror
- Excel Pivot Table
- Move Pivot Tables
- Excel Drop-Down list
- Conditional Formatting
- Excel Hyperlink
- Excel Vlookup
- Excel Hlookup
- Excel Protect Sheet
- Excel Macros
- Excel Insert Images
- Excel Concatenate
- Excel Text To Column
- Remove Duplicates
- Excel Cell Formatting
- Group in Excel
- Excel Comments
- Excel Freeze Panes
- Excel Charts
- Print in Excel
- Excel Transpose
- Reminders in Excel
- Reduce Excel File Size
- Percentage in Excel
- Substitute Function

EXCEL FORMULAS Excel Tutorial Excel Introduction Excel Addition(+) Excel Subtraction(-) Multiplication(*) Excel Division(/) Excel IF Function Excel SUMIF Count & CountIF Excel IFerror Excel Pivot Table Move Pivot Tables Excel Drop-Down list Conditional Formatting Excel Hyperlink Excel Vlookup Excel Hlookup Excel Protect Sheet Excel Macros Excel Insert Images Excel Concatenate Excel Text To Column Remove Duplicates Excel Cell Formatting Group in Excel Excel Comments Excel Freeze Panes Excel Charts Print In Excel Excel Transpose Reminders in Excel Reduce Excel File Size Percentage in Excel Substitute Function

How to Subtract | Subtract Syntax | Examples

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.

0 Comments

* 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.