Assigns a value to a variable. |
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 |
Taken |
[Complete] |
When cell execution completes. |
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. |