All Commands
All Math & Logic
Commands
VAL
Return the Numeric value of a character string.
Good to use this in an IF statement to wrap around an OBJ_DATA command when comparing values to ensure the comparison is done on a value rather than an empty string.
NOTE: Numbers wrapped in brackets e.g. (£10.25) will be treated as negative values. As is the standard in accountancy.
| Number | Name | Default | Type | Description |
|---|---|---|---|---|
| 1 | value | 0 | String |
Example
123456.78
10.25;
12
2345.67
0
10.25;
12
2345.67
0