assignglobal(
VALUE
,
VARIABLE
)

The assignglobal( function assigns a value to a global variable (creating the variable if necessary).


Parameters

This function has two parameters:

value – The value to be stored in the variable. This value is also returned as the result of the function.

variable – The name of the global variable to store the value into. If this global variable does not exist, it will be created.


Description

This function assigns a value to a global variable (creating the variable if necessary). This is called a side effect because this assignment is in addition to the normal operation of the formula. The assignglobal( function also returns the VALUE parameter as it’s value. If you don’t want to use this value in your formula use the ignore( function.

In this example both A and B will be assigned the value X+Y. If the global variable A does not exist it will be created.

B=assignglobal(X+Y,"A")

See Also


History

VersionStatusNotes
10.0NewNew in this version.