We rebuilt the editor. Less panel hunting. More shaping.

Guide

How To Subtract In Google Sheets

Perform subtraction calculations in Google Sheets using formulas. Learn how to subtract values between cells using the =A1-B1 formula.

Interactive tour · Open canonical tour

  1. Open Google Sheets and select a cell where you want the result.

  2. Type the formula =A1 - B1 (replace A1 and B1 with your desired cell references).

  3. Press Enter, and the result will appear in the selected cell.

  4. Drag the fill handle down to apply the formula to multiple rows if needed.

  5. You can also subtract multiple values using =A1 - B1 - C1.

  6. For constant values, use =10 - 5 directly in a cell.