And one disadvantage if this method is that it would need an additional column for you to get the result (which is not such a big problem in most cases). In case you change the value in cell A2, the resulting data would automatically update. Note: Using the formula method has an advantage – which is that the result is dynamic. You will now get a whole column of cells containing the difference between cell A2 and cells B2:B11. You can also manually add these dollar signs if you want. Notice that the cell location A2 changes to $A$2. The easiest way to do this is by using a simple subtraction formula. Let us say you have a dataset as given below (cells B2:B11) and you want to subtract each of these values from the value in cell A2. Subtract Multiple Cells from a Cell using a Formula
Difference between Absolute and Relative Cell References in Excel.Subtract Multiple Cells from a Cell using a Formula.
