Syntax:
SET_NAME(name:Text, expression)
Sets the name to be the expression.
Example:
SET_NAME("TAX_RATE", C2)
sets the name TAX_RATE
to be the reference C2
.
Other calculations can use the name TAX_RATE
in their calculations,
and the reference C2
will be used whenever TAX_RATE
is named as a parameter.
Note that although you must specify the name within quotes when defining it using the SET_NAME
function,
you would not put it in quotes when referring to it elsewhere in the worksheet.
You can use this function to set a name for any external references you use.
Setting a name in the supporting document and using it from the dependent document will enable you to edit the supporting document without the dependent document loaded, and without the risk of cell references becoming out of date.