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
Percentage increase
Let’s say that you have a Form with data that shows the yearly yields of certain products on different Farms. You can use a Calculated Field with a combination of Formulas to calculate the percentage difference between the yearly yields.
To do so, you would use the SUBTRACT (-), DIVIDE (/) and MULTIPLY (*) Formulas along the logic of: (New value minus Old value) divided by the Old value, multiplied by 100).
((yield_2022 - yield_2021) / yield_2021) * 100