# Subtraction operator (-)

**-**Value2

## Value1 — Number or { Number }

The number to subtract from (the *minuend*).

## Value2 — Number or { Number }

The number which should be substracted from the first number (the
*subtrahend*).

## Returns — Number or { Number }

The difference between the numbers.

Subtracts one number from another and returns the result. 8 - 38 - 3 returns 5.

This operator also works with arrays. { 8, 9 } - 6{ 8; 9 } - 6 returns the array { 2, 3 }{ 2; 3 } (equivalent to { 8 - 6, 9 - 6 }{ 8 - 6; 9 - 6 }) and { 8, 9 } - { 6, 10 }{ 8; 9 } - { 6; 10 } returns the array { 2, -1 }{ 2; -1 } (equivalent to { 8 - 6, 9 - 10 }{ 8 - 6; 9 - 10 }).

## Subtracting many values

The SUM function is equivalent to this operator, provided that all parameters other than the first one are negated.

These formulas both return 5:

However, SUM can be invoked with arrays with an arbitrary number of elements.
To subtract the field values of the Field2:Field4Field2:Field4 range from the value of
*Field1* and return the result, use this formula:

(The Field2:Field4Field2:Field4 range is a short-hand way
of expressing an array containing *Field2* and *Field4*, as
well as any fields that appear between them, such as *Field3*. If only
*Field3* appears between the other two fields, Field2:Field4Field2:Field4 and { Field2, Field3,
Field4 }{ Field2;
Field3; Field4 } are equivalent.)