SUBTRACT

Subtracts multiple values in sequence and returns the resulting difference to support numeric calculations.

The SUBTRACT function subtracts a series of values and returns the resulting number. It deducts subsequent values from the first value provided and is commonly used in calculations where differences between numbers need to be determined.

Syntax

SUBTRACT(value1,value2,...valueN)

Arguments

value1, value2 – Can be numbers or cell references (Required).

Example

SUBTRACT(COLUMN1,COLUMN2)

In the example below, the Subtracted Values measure is created using the SUBTRACT function, which returns the result of subtracting MEASURE 2 from MEASURE 1.

Applying SUBTRACT function