How to subtract cells in Google Sheets
By
SpreadCheaters
Page last updated:
19/04/2023 |
Next review date:
19/04/2025
You can watch a video tutorial here.
Google Sheets is a great tool for performing calculations across many columns and creating complex formulas. When creating a calculated column, you may need to subtract values in cells.
Step 1 – Create the formula
– Select the first cell in the ‘Profit’ column
– Type in the formula using cell references:
= Sales price – Material cost – Labour
– Press Enter
Step 2 – Copy the formula
– Using the fill handle from the first cell, drag the formula to the remaining cells
OR
a) Select the cell with the formula and press Ctrl+C or choose Copy from the context menu (right-click)
b) Select the rest of the cells in the column and press Ctrl+V or choose Paste from the context menu (right-click)
Step 3 – Check the result
– The cells are subtracted
