SUBTRACT (-)

Description

The SUBTRACT (-) operator subtracts one number from another.

Usage

a - b

Both a and b must be numbers. You can use the VALUE function to convert text arguments to numbers.

To find the difference between two dates, use the YEARFRAC function or the DAYS function.

If both a and b are blank, then the result is also blank. However, if only one is blank, the blank value is treated as zero.

Example

If you have conducted an assessment of the number of families in IDP camps, and the number of available tents, you can calculate the gap using the formula:

NUMBER_HOUSEHOLDS - TENTS
Next item
SUM