How To Subtract In
Google Sheets
Open Google Sheets and select a cell where you want the result.
Type the formula
=A1 - B1
(replaceA1
andB1
with your desired cell references).Press Enter, and the result will appear in the selected cell.
Drag the fill handle down to apply the formula to multiple rows if needed.
You can also subtract multiple values using
=A1 - B1 - C1
.For constant values, use
=10 - 5
directly in a cell.