Documentation/Calc Functions/CONVERT OOO
Converts a value from one unit of measurement to another unit of measurement. The conversion factors are given in a list in the configuration.
CONVERT_OOO(Value; "Text 1"; "Text 2")
Returns a non-negative real number which is the convert amount in required measurement for the given amount in initial measurement.
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.
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.
|=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:
Equivalent Excel functions: