How To Do Subtraction In Excel?

Use the minus sign: `=A1-B1`

Subtract multiple cells: `=A1-B1-C1`

Subtract a number from a cell: `=A1-5`

Subtract cells across rows or columns by dragging the fill handle

Use parentheses to control order: `=(A1-B1)-C1`

Subtract dates: `=B1-A1`

Subtract times: `=B1-A1`

Use AutoSum dropdown and choose Sum, then subtract manually with `-`

Copy the formula to other cells to apply subtraction to more values

Suggested for You

Trending Today