You need to follow the steps below to complete the operation. Suppose you want to subtract or add two cells in Excel.
Subtracting and Adding Cell References in One Formula To do this, simply enter the minus sign in the cell where you want your answer to appear, followed by the cell reference of the first column, and then the cell reference of the second column.
For the purpose of demonstration, we have used the following sample dataset.ġ. The simplest way to subtract two columns in Excel is by using the minus sign. In this article, we will show you some easy ways of adding and subtracting in Excel in one formula. But subtraction becomes tough as it doesn’t have any direct formula. You can create complex formulas and perform certain operations directly in Excel. Way 1: Performing Calculations from Left to Right We can evaluate this expression in two ways: The following example may help in this regard. Notes: You get the SUM function to add numbers or a range of cells.Īdding and Subtracting in one Excel Formula: 4 Easy WaysĪddition and subtraction can be done in one mathematical expression.
