If you need to subtract a single value from each number within a cell range, you can copy the formula to other cells. Subtract One Number from Each Value within a Cell Range B5 will now return the value 200 as shown below. Input the formula ‘ =B3-B4‘ and press the Return key. To subtract cell values, you’ll need to include their row and column references in the formula instead. However, most Excel users will need to subtract numbers entered in spreadsheet columns and rows. The formula’s cell will return the value 20.
For example, input ‘ =25-5‘ in the function bar and press Enter. Then click in the Excel function bar and input ‘ =‘ followed by the values you need to deduct.First, select a cell to add the formula to.
