Within each group, a set of base unit symbols is defined (for example, the Temperature group includes symbols for Celsius, Fahrenheit, kelvin, and other units). CONVERT will perform conversions between any two units within one group but reject any request to convert between units in different groups.

The measurement units recognized by CONVERT fall into 13 groups, which are listed in the #Summary: section above.

If FromUnit and ToUnit are not valid units of the same type, then CONVERT reports an invalid argument error (Err:502).

If Number is non-numeric, then CONVERT reports a #VALUE! error.

Both FromUnit and ToUnit must be of the same unit type. ToUnit is a string, or a reference to a cell containing that string, that is an abbreviation signifying the unit to which conversion is taking place.

Number is a real number, or a reference to a cell containing that number, that is the value to be converted from one unit to another.įromUnit is a string, or a reference to a cell containing that string, that is an abbreviation signifying the unit from which conversion is taking place. Returns a real number which is the converted value expressed in the specified unit of measure. Converts a value expressed in one unit of measure to the corresponding value in another, compatible measurement system.ĬONVERT is a wide-ranging function capable of converting values in many different types of measurement systems, covering:

Error 502 openoffice calc