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.