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