How to use subtraction in Excel

Excel functions or Excel formulas are all basic tools for users to process data in data tables. Subtraction in Excel has no calculation function to implement, but we will use the '-' operator. Subtraction is used for many different cases, except for many cells in the data table, except for the percentage in Excel to apply to each different calculation. The following article will guide you how to use subtraction in Excel as well as some examples of subtraction.

1. The easiest way to calculate the percentage (%)
2. How to use the kernel function (PRODUCT function) in Excel
3. 3 ways to calculate totals in Excel
4. How to automatically calculate and copy formulas in Excel

Instructions for performing subtraction in Excel

1. Subtract many cells in Excel

To perform calculations except for many cells in Excel, we will use the '-' operator or use the SUM function in Excel.

Example 1: Use a minus sign

With the use of the minus sign, we only need to enter the = sign and then enter the subtraction for the numbers to be calculated in the data table and press Enter to get the result.

How to use subtraction in Excel Picture 1

Example 2: Use the SUM function

The SUM function for calculating subtraction in Excel will have 2 ways to do it. We will add - to convert arguments to negative values , thus subtracting. Follow the way through the example table below.

How to use subtraction in Excel Picture 2

Or we use the formula = D3-SUM (D4: D5) and also give the same result. The simple interpretation of this calculation is D3- (D4 + D5).

How to use subtraction in Excel Picture 3

2. Subtract percentages from Excel

The subtraction of% in Excel is still done as usual when calculating subtraction.

How to use subtraction in Excel Picture 4

Or if you want to perform subtraction from a number to calculate the percentage value, press the formula = Number * (1-x%). You follow how to follow the example below.

How to use subtraction in Excel Picture 5

3. Subtract dates from Excel

The simple way to do it is to use the '-' sign in the calculation except the date. Or we use the DATE function in Excel to calculate the date value.

How to use subtraction in Excel Picture 6

Above is how to use subtractions in Excel and some examples using subtraction. Subtraction is very simple, just apply the '-' operator.

I wish you all success!