Map and Table Calculation

VALUE( ) function

Converts a string with numbers to a value.

Syntax

VALUE(String)

Input

String is a string consisting of numbers, optionally preceded with a minus sign and optionally containing a dot.
Domain type: system domain String

Output

VALUE returns: a real value
Domain type: system domain Value

Notes:

Tip:

When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.

Usable in

TabCalc, Simple calculators

Examples

Pocket line calculator examples:

? VALUE("45")

returns 45.000

? VALUE(-38.5)

returns -38.500

TabCalc example:

OutCol1 = VALUE(InCol1)

OutCol2 = VALUE(SUB(InCol2,2,2))

 

InCol1

InCol2

OutCol1

OutCol2

0

A11

0.000

11

0.1

A12

0.100

12

-1.5

A20

-1.500

20

25

A30

25.000

30

999

B10

999

10

A300

B21

?

21

ABC

B22

?

22

?

?

?

?

Column ColOut2 contains the values of a sub string of column InCol2. The sub string starts at position 2 and takes 2 characters into account; when the result of the sub string is a number, then this is converted to a value.

See also: