:CONVERT function, a versatile unit converter-Table skills免费ppt模版下载-道格办公

CONVERT function, a versatile unit converter

  • Picture and text skills
  • Case

Convert numbers from one measurement system to another. For example, the function CONVERT can convert a distance table in miles to

Change to a distance table in kilometers.


Syntax
CONVERT(number,from_unit,to_unit)
Number The value to be converted in from_units.
From_unit The unit of value number.
To_unit is the unit of the result. The function CONVERT accepts the following text values ​​(in quotes) as from_unit and to_unit.

 

 332.png

Description

If the input data is spelled incorrectly, CONVERT returns the #VALUE! error value.

If the unit does not exist, CONVERT returns the error value #N/A.

If the unit does not support abbreviated unit prefixes, CONVERT returns the error value #N/A.

CONVERT returns the #N/A error value if the units are in different groups.

Unit names and prefixes are case-sensitive.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/CONVERT-han-shu-quan-neng-de-dan-wei-zhuan-huan-qi.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion