subtraction excel formula multiple cells

We may have to try different approaches depending on how the data is organized and how we want to subtract the desired data. However, Excel has several alternate methods we can use to do subtraction within the worksheet. Unfortunately, there is no definite SUBTRACT function like Excel's SUM function. We discuss a few step-by-step methods for subtracting between data based on use cases, including related example data sets. In this tutorial, we discuss various step-by-step methods or solutions on how to do subtraction in Excel.

Subtraction is one of the four primary arithmetic operations and is most often used in Excel. Since Excel is spreadsheet software, it allows performing calculations between the recorded data sets. Although it enables users to record almost all data types, numbers are the most commonly used data within the cells in an Excel worksheet. With Excel, users get an option to record vast amounts of data sets. Method 1: Minus sign Simply type a negative sign between many cell references, when subtracting multiple values.įor example, to subtract cells B2:B6 from B1, write the following formula: = B1-B2-B3-B4-B5-B6.Next → ← prev How to do subtraction in Excel? How to subtract multiple cells from one cell in Excel You can use any of the following methods to remove several cells from a single cell. To finish your formula, press the Enter key.To add a reference to the formula, click on the cell containing a subtrahend (a number to be subtracted) (B2).

Its reference will be immediately included in the formula (A2).

Select the cell that contains a minuend (a number from which another number is to be subtracted).To begin your formula, type the equals symbol (=) in the cell where you want to output the difference.You don't have to enter cell references manually, and you can rapidly add them to the formula by selecting the appropriate cells.To subtract the number in B2 from the number in A2, use the following formula: =A2-B2.To subtract one cell from another, use the minus formula, but instead of integers, use cell references: = cell_1 – cell_2.Also Read - What is the factorial of hundred?

Subtraction excel formula multiple cells