Operators And Functions

Operators indicate an operation to be performed on one or more parts of the formula. The following operators are supported:

Arithmetic Operators

+

*
/

Comparison Operators

=
>
<
<>
<=
>=

Text Operator & (string concatenation)
Formula Syntax Operators

(
)
,

Note: When concatenating fields and one of the fields is Null, the entire returned string will be Null. In this case, use ISERROR to return the existing field. For example:

S14&IF(ISERROR(S15),"",S15)


See the CONCATENATE function for more information.
 

A function returns a value based on the results of a pre-defined calculation. You can see the complete list of supported functions from the Function Browser in the Edit Formula dialog box.

Help for each function displays when you highlight a function name in the Function Browser. 

See also

Formula Editor

Data Limitations

Editing Multiple Formulas