Documentation/Calc Functions/CONVERT OOO
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
CONVERT_OOO
Category:
Mathematical
Summary:
Converts a value from one unit of measurement to another unit of measurement. The conversion factors are given in a list in the configuration.
Syntax:
CONVERT_OOO(Value; "Text 1"; "Text 2")
Returns:
Returns a non-negative real number which is the convert amount in required measurement for the given amount in initial measurement.
Arguments:
Value is a non-negative real number which is the amount in initial unit of measurement.
"Text 1" is a string to mention the initial unit of measurement.
"Text 2" is a string to mention the final unit of measurement into which the amount is to be converted.
Additional details:
At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies.
Examples:
Formula | Description | Returns |
---|---|---|
=CONVERT_OOO(100;"ATS";"EUR") | converts 100 Austrian Schillings into Euros | 7.26728341678597 |
=CONVERT_OOO(100;"EUR";"DEM") | converts 100 Euros into German Marks | 195.583 |
Related LibreOffice functions:
ODF standard:
None
Equivalent Excel functions:
None