Subtraction operator (-)
Value1
The number to subtract from (the minuend).
Value2
The number which should be substracted from the first number (the subtrahend).
Returns
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.)