Can you subtract in excel

Let's try the previous example with the SUM function. You'll get the same results as the previous example with this formula, albeit the formula itself will look tidier. You can also use subtract to reduce a value by a percentage. This is done using some basic math and the overall formula is as below:. Let's see this in action. We're going to subtract the commissions and calculate the net earnings.

You can subtract times in Excel the same way as the previous values. The trick to subtracting times is to change the cell format to time so that Excel comprehends the cells as time values. Say you have two different times, one for the start of an event and one for the finish, and you want Excel to calculate the elapsed time. To do this, you'll have to change the format of all three cells to time, and then write a simple subtraction formula.

Suppose you have a dataset as shown below where you want to subtract the value in cell D2 with all the cells in column A. It will take care of it itself. Similar to the above example, you can also delete values in an entire column from a single value or the cell that holds the value. Suppose you have a data set as shown below and you want to subtract all the values in column B from the value in cell A2.

In most practical cases, you will have two columns where you want to subtract the cells in each column in the same row and get the result. For example, suppose you have the Revenue and Expense values in two columns and you want to calculate the Net Income which is the difference between revenue and expenses.

Suppose you have the same data and you want to subtract the two columns, you can use the below formula:. Note that this is made possible because Excel in Microsoft has something called Dynamic Arrays. For example, if you have two dates, you can subtract these and find out how many days have elapsed between these two dates.

There is a possibility that Excel will give you the result in the date format instead of a number as shown above. This sometimes happens when Excel tries to be helpful and pick up the format from the adjacent column. You can easily adjust this and get the values in numbers by going to the Home tab, and select General in the number format drop-down. Note: This formula would only work when you using a date that Excel recognizes as a valid date format.

For example, if you use You can read more about subtracting dates in Excel here. Let's say you want to find out how many inventory items are unprofitable subtract profitable items from total inventory. Or, maybe you need to know how many employees are approaching retirement age subtract the number of employees under 55 from total employees.

Subtract numbers in a cell. Subtract numbers in a range. To do simple subtraction, use the - minus sign arithmetic operator. Adding a negative number is identical to subtracting one number from another. Use the SUM function to add negative numbers in a range. Use the SUM function and convert any numbers that you want to subtract to their negative values. For example, SUM ,,15,-6 returns Need more help? Expand your skills. Get new features first.

Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve?