Skip to main content

Cell operators

The following operators may be entered in cells instead of typing in values.

Copy operators

OperatorFunction
=To copy the value from the same cell in the preceding record.
=nTo copy the value from the same cell in record n.
==To copy the values from the same cell and all following cells in the preceding record.
==nTo copy the values from the same cell and all following cells in record n.

Increment operators

The increment operators copy the value from the same cell in the preceding record and perform an operation on that. They apply to numeric fields only.

OperatorFunction
+=fTo add f to the copied value.
−=fTo subtract f from the copied value.
*=fTo multiply the copied value by f.
/=fTo divide the copied value by f.

If the increment, f, is omitted then the default value is used as the increment.