👉 🔥 CLICK HERE! 🔥 👈

Subtraction in Excel is like subtraction in real life — its straightforward. You simply need to keep in mind that unlike other common arithmetic functions like addition, multiplication, and division, theres no subtraction function in Excel. That means you cant issue some sort of subtract command. Instead, to subtract, you sum with negative numbers. There are a few common ways to do this. Standard subtraction in Excel is relatively simple. Click in an empty cell, type an equal sign and then enter the numbers you want to subtract. You can enter two or more numbers and add and subtract at the same time. According to the usual order of operations, it doesnt matter what order you list the numbers in, as long as you are only adding and subtracting. For example, type:=100+50-10-20Then press Enter. You will get a result of 120. To subtract in Excel, use a minus sign just like you would doing arithmetic on paper. Dave Johnson Thats the same as if you did the same steps and entered:=50-10+100-20 You dont have to subtract numbers in a single cell; you can also set up a formula that will subtract the values stored in multiple cells. For example, suppose you wanted to subtract the value of A2 from the value of A1. Enter some values in A1 and A2. For example, 100 and 25. Then click A3 and press =. Click cell A1 and the label A1 automatically appears in A3. Press the minus sign (-) and then click the cell A2. Press Enter. You should now see the result of 75 appear in A3. You can subtract one cell from another in Excel. Dave Johnson You can use the previous technique to subtract cells, but if you have several cells you want to subtract, there is an easier method — you can subtract a range of cells all at once. Suppose you have a set of numbers stored in cells A1 through A10, and you want to subtract them. Using the SUM function, we can calculate the result easily. In fact, this function can combine addition and subtraction into a single operation — you simply need to put a minus sign in the cell of every number you want to subtract (this means the number will look like a negative number). 1. Enter the numbers you want to use in each cell from A1 through A10. Remember that any numbers you want to subtract should have a minus sign (-).2. Click the cell where you want the final result to appear (such as A11). Type =SUM(. That is an equal sign, the word SUM, and an open parenthesis. 3. Click cell A1. While holding the mouse button, drag the mouse from A1 all the way to A10. Release the mouse button.4. Press Enter. Excel will close the parenthesis for you automatically and perform the calculation. You can add and subtract using the SUM function. Dave Johnson 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. How to Use the Subtraction Formula in Excel? The subtraction formula of Excel is easy to use. Let us go through the following examples to understand its working. Example #1 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: Enter the comparison operator equal to (=), followed by the cell B4, the minus sign (-), and the cell A4. Press the Enter key. The output is 67. Note: The references B4 and A4 can either be typed or selected by clicking on the respective cells. Apply the subtraction excel formula to the remaining values. Alternatively, drag the formula of C4 till C13, as shown in the following image. The final output appears, as shown in the following image. For simplicity, we have retained the formulas in column C and given the differences in column D. Note: If the values in column A or column B change, the result is automatically updated in column D. Example #2 The 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. It always begins with the comparison operator equal to (=).It requires the insertion of the arithmetic operator minus (-) between two values.It is used in both, simple and advanced mathematical problems where a comparison between two values is required.It can be used in combination with other arithmetic operators like plus (+), percent (%), forward slash (), asterisk (*), and so on. Frequently Asked Questions 1. 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: • Enter the comparison operator equal to (=). • Enter the first number, followed by the minus sign (-), and the second number. Alternatively, select the cells containing values. • Press the Enter key and the result appears in the cell where the formula was entered. 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.• Apply the formula =A1-SUM(A12:A15). • Place the minus sign (-) before the numbers in cells A12, A13, A14, and A15. Apply the formula =SUM(A1,A12: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 Articles This 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 –

Items