GETREF Function
References a cell and doesn't recalculate the formula when the referenced cell changes.
Syntax
GETREF(cellname)
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
cellname |
Required |
String |
The name of the cell to get a reference to. |
Example
SETF(GETREF(PinX),5.1)
Sets the formula of the PinX cell to 5.1.