Description
The ADD (+
) operator adds two numeric values together.
Usage
a + b
Remarks
Both a
and b
must be numbers. To combine text, use the CONCAT function or use the VALUE function to convert the arguments to numbers.
To add days to a date, use the ADDDATE 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 a form with two quantity fields WOMEN
and MEN
, you could add a calculated field to find the total number using:
WOMEN + MEN