The subtraction formula in excel facilitates the subtraction of numbers, cells, percentages, dates, matrices, times, and so on. It begins with the comparison operator “equal to” (=) followed by the first number, the minus sign, and the second number. For example, to subtract 2 and 5 from 15, apply the formula “=15-2-5.” It returns 8. In subtraction, the first number is the
minuend (from which a number has to be subtracted) and the second number is the subtrahend (the number to be subtracted). The resulting number is the difference. The arithmetic operator “minus” (-) is placed between the minuend and the subtrahend. The subtraction formula of Excel is easy to use. Let us go through the following examples to understand its working. The following
table shows some values in columns A and B. We want to subtract the values in column B from those of column A. The steps to subtract the values of column B from those of column A are listed as follows: Note: The references B4 and A4 can either be typed or selected by clicking on the respective cells. Note: If the values in column A or column B change, the result is automatically updated in column D. Example #2The following table shows the names and the revenuesRevenue is the amount of money that a business can earn in its normal course of business by selling its goods and services. In the case of the federal government, it refers to the total amount of income generated from taxes, which remains unfiltered from any deductions.read more generated (in Rs.) by ten employees of an organization. It has been decided to award Rs. 10,000 worth vouchers to those employees who have achieved the sales target of Rs. 5000. Find the employees eligible for the reward. Step 1: Enter the following formula. “=B19-$C$19” To calculate the revenue generated over and above the target (Rs. 5000), we subtract the latter (column C) from the former (column B). Since the target amount is the same for all the employees, we use the absolute referenceAbsolute reference in excel is a type of cell reference in which the cells being referred to do not change, as they did in relative reference. By pressing f4, we can create a formula for absolute referencing.read more $C$19. Note: In absolute cell reference, the dollar sign ($) is placed before the column letter and the row number like in $C$19. This keeps the column and the row constant. Step 2: Press the “Enter” key. The final output appears in column D, as shown in the following image. For simplicity, we have retained the formulas in column E and given the differences in column D. The employees who have negative difference values (column D) are not eligible for the reward. Hence, Henry and Fedrick are not eligible while the rest of them receive the gift voucher. The Rules Governing the Subtraction Excel Formula
Frequently Asked Questions1. What is the subtraction formula of Excel and how to use it? MS Excel does not have a SUBTRACT function. However, it facilitates subtraction by the insertion of the “minus” sign (-) between two values. The basic subtraction formula is stated as follows: “=number 1-number 2” The usage of the subtraction excel formula is listed in the following steps: 2. How to use the subtraction formula for multiple cells in Excel? There are various ways of subtracting multiple cells from a single cell. For example, let us subtract the cells A12, A13, A14, and A15 from the cell A1. Select any one of the following three methods: • Apply the formula “=A1-A12-A13-A14-A15”. 3. How to use the subtraction formula for calculating time in Excel? To calculate time, apply the following formula: “=End time-Start time” For example, cells A6 and B6 contain 2:30:00 and 7:00:00 respectively. The number of hours in between the two times are calculated by the formula “=B6-A6”. The difference is 4:30:00. Note: For correct results, apply the time format to the cell containing the formula. Recommended ArticlesThis is a guide to the subtraction formula in Excel. Here we discuss how to subtract two numbers in excel with step by step examples. You can download the Excel templates from the website. For more on Excel, take a look at these functions –
Which operator does Excel calculate first?Calculation order
A formula in Excel always begins with an equal sign (=). Excel interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references.
Which of the following is entered first when creating a formula in Excel?On the worksheet, click the cell in which you want to enter the formula. Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. For our example, type =1+1.
Which operator is used in Excel before starting any formula?Calculation order
A formula in Excel always begins with an equal sign (=). The equal sign tells Excel that the characters that follow constitute a formula. After this equal sign, there can be a series of elements to be calculated (the operands), which are separated by calculation operators.
Which operation is calculated first?The order of operations are the rules that tell us the sequence in which we should solve an expression with multiple operations. The order is PEMDAS: Parentheses, Exponents, Multiplication, and Division (from left to right), Addition and Subtraction (from left to right).
|