Cell operators
The following operators may be entered in cells instead of typing in values.
Copy operators
Operator | Function |
---|---|
= | To copy the value from the same cell in the preceding record. |
=n | To 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. |
==n | To 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.
Operator | Function |
---|---|
+=f | To add f to the copied value. |
−=f | To subtract f from the copied value. |
*=f | To multiply the copied value by f. |
/=f | To divide the copied value by f. |
If the increment, f, is omitted then the default value is used as the increment.