Documentation/Calc Functions/VALUE

From The Document Foundation Wiki
Jump to navigation Jump to search



Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

VALUE

Category:

Text

Summary:

Converts a text string into a number.

Syntax:

VALUE("Text")

Returns:

Arguments:

Text is the text to be converted to a number.

Additional details:

Examples:

=VALUE("4321") returns 4321

=VALUE("abc") returns Err:502 (Invalid argument)

=VALUE(A1) returns Err:502 (Invalid argument) where A1 contains abc

=VALUE("abc123") returns Err:502 (Invalid argument)

=VALUE(A1) returns 4321 where A1 has the text format and contains 4321

=VALUE(A1) returns 4321 where A1 contains '4321

=VALUE(A1) returns 0 where A1 is an empty cell

=VALUE(4321) returns 4321

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: