Documentation/Calc Functions/CONVERT OOO

From The Document Foundation Wiki
Jump to: navigation, search

Other languages:
dansk • ‎English

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:

EUROCONVERT

ODF standard:

None

Equivalent Excel functions:

None