1. Home
  2. Functions
  3. Math
  4. MINUS

MINUS function

Returns the difference of two numbers, like the - operator.

Syntax

=MINUS(value1, value2)

Arguments

ArgumentRequiredDescription
value1RequiredThe first number
value2RequiredThe second number

How to use MINUS

MINUS takes 2 required arguments. Type =MINUS( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.

Examples

Each result below was calculated by the SheetsBat formula engine.

=MINUS(8, 3)Result 5

Every formula, right in your browser

SheetsBat calculates 536 functions, with charts, pivot tables and live collaboration. Free to start.