next up previous contents index
Next: VAR, VARP Up: A. Function Reference Previous: UPPER   Contents   Index


VALUE

Syntax: VALUE(S)

S = a string value

VALUE returns the numeric value represented by string S, or 0 if S does not represent a number.

Examples:

VALUE(``324.399'') = 324.399

VALUE(G10) = 1.7, where G10 = ``1.7''

VALUE(M8) = 0, where M8 = ``cosine''

Excel function: VALUE


next up previous contents index
Next: VAR, VARP Up: A. Function Reference Previous: UPPER   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003