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.