Assign Variable

Assigns a value to a variable.

Properties

Set the destination variable

Enter the variable that will store the assigned value. This must not be of type date.

Set the source variable

Enter the value to assign (a literal value or another variable). If the type does not match the destination variable, it is converted at run time. See 'Remarks' below.

Exit point

Exit point

Taken

[Complete]

When cell execution completes.

Remarks

Source type

Destination type

Converts

String

Float or integer

A string of numeric characters to a numeric value.

Useful for converting a captured numeric string to a monetary value.

String

Boolean

Zero to false; all other values to true.

Float or integer

String

The number to a character string.

Float or integer

Boolean

Zero to false; all other numbers to true.

Boolean

String

true to 1; false to 0.

Boolean

Float or integer

true to 1; false to 0.