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