The SUBTRACT (
-) operator subtracts one number from another.
a - b
b must be numbers. You can use the VALUE function to convert text arguments to numbers.
b are blank, then the result is also blank. However, if only one is blank, the blank value is treated as zero.
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