ADD (+)

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
Next item
ADDCOLUMNS