[{"id":"b66f8b1e-cc14-4e89-9679-abd5687d283d","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"569bb90a-ea68-46c6-96f1-ab151c120714","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"5eb52f08-2d1a-4362-9ffc-4871bdc10f3f","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"341dd607-b97d-4d70-bde2-53acda6b6c95","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"05349273-414f-4208-9ea2-c4fc8f4ea2cb","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"86089f76-b778-4d52-821e-6f27de3df613","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b81e4fd6-1fc5-43a0-a258-b6e16a5cbec6","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"8aa8ce31-43e4-438e-951f-241608435260","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"37343f41-6ec2-4c7e-b21d-2cc18d5ce1e0","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"5915e52f-64f8-4146-b8bd-81bead6324a3","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"836ba889-af9e-460d-a4cc-c24d922795f2","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4ae14b06-bb68-4394-a210-a46b8f028346","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d8f42066-e9dc-4411-bdcf-43b1a203370c","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"7ef86f16-b1a0-49f7-9592-612b9be02b25","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b29c7775-a9a4-451e-a1b5-01d19ed5ca5e","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"e56f3989-8f81-46af-90fa-a4813eeb976f","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"2526c963-f170-45a8-923e-91b0712a9810","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"24575cf0-501a-44f9-8426-c40f8f4b5552","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"1a6f8d7f-acd6-42be-8c4f-f464c6218381","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"82b176fd-5cab-498c-909e-8fa7d29c38d8","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"1708b3a9-4f37-44a8-8f0e-f9a2d2e5d940","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"c9ac246e-29fb-4bc4-8231-8439795bb590","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"94f2a5c3-2539-436a-af75-23fbbd1a3957","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d99594f4-2d40-4df4-9419-ba2ca6aa3f7f","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"fd66e72d-0f10-4f57-9807-6db26290ab2e","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"8f344863-503d-4bc3-a594-3815e7d55f5c","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"9be82601-de9d-4c18-948a-23ab6f4dd431","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"6495f3c0-b463-47e0-b08a-ca949672211e","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b4bede08-3f08-4839-ba4a-abc7ac195bde","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4afcdfc0-3ff5-4f2b-a223-f8fc042a5bbe","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"422062c4-fa40-4771-a86f-008efe6d86e5","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d87e8013-86a7-4840-8d25-6f62e14eb4ac","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"a6acedfd-4043-4c64-a5d1-aec3326df9e7","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"dbdc0b24-06c4-48b9-8d6c-7455119dc773","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"a3856849-954a-4cfc-96a6-382e530d3638","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4a39306b-ffa5-433d-80a3-28e41f929b72","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]}]
        
(Showing Draft Content)

CONVERT

此函数将数字从一种度量系统转换为另一种度量系统。

语法

CONVERT( number , from-unit , to-unit )

参数

此函数有以下参数:

参数 描述
number 需要进行转换的数值。
from-unit 是数值的单位。
to-unit 是结果的单位。

注释

度量系统是一组用于不同类型测量的单位。此函数将一组单元的数值转换为一组不同单元的数值。

如果单位在不同的组中,函数 CONVERT 返回错误值 #N/A。

下表按单元类型列出了可转换单元:

重量和质量 可转换单元
"g"
斯勒格 "sg"
磅(常衡制) "lbm"
U(原子质量单位) "u"
盎司(常衡制) "ozm"
"grain"
美国(短)英担 "cwt" 或 "shweight"
英制重量 "uk_cwt" , "lcwt" 或 "hweight"
"stone"
"ton"
英制吨 "uk_ton" , "LTON" 或 "brton"
距离 可转换单元
"m"
法定英里 "mi"
海里 "Nmi"
英寸 "in"
英尺 "ft"
"yd"
"ang"
厄尔 "ell"
光年 "ly"
差距 "parsec" 或 "pc"
皮卡(1/72英寸) "Pica"
皮卡(1/6英寸) "pica"
美国调查英里(法定英里) "survey_mi"
时间 可转换单元
"yr"
"day"
小时 "hr"
分钟 "mn"
"sec"
压强 可转换单元
帕斯卡 "Pa"
大气压 "atm"
毫米汞柱 "mmHg"
磅/平方英尺 "psi"
"torr"
可转换单元
牛顿 "N"
达因 "dyn"
磅力 "lbf"
"pond"
能量 可转换单元
焦耳 "J"
尔格 "e"
热力学卡 "c"
IT 卡 "cal"
电子伏 "eV"
马力-小时 "Hph"
瓦特-小时 "Wh"
英尺磅 "flb"
英热单位 "BTU"
功率 可转换单元
英制马力 "HP"
帕斯卡 "PS"
"W" 或 "w"
可转换单元
特斯拉 "T"
高斯 "ga"
温度 可转换单元
摄氏度 "C"
华氏度 "F"
开氏温标 "K"
沸点 "Rank"
冰点 "Reau"
容积(或液体度量) 可转换单元
茶匙 "tsp"
现代茶匙 "tspm"
汤匙 "tbs"
液量盎司 "oz"
"cup"
美制 品脱 "pt"
英国 品脱 "uk_pt"
夸脱 "qt"
英制夸脱(英国) "uk_qt"
加仑 "gal"
英制加仑(英国) "uk_gal"
"l"
立方埃 "ang3" 或 "ang^3"
美国 油桶 "barrel"
美国 蒲式耳 "bushel"
立方英尺 "ft3" 或 "ft^3"
立方英寸 "in3" 或 "in^3"
立方光年 "ly3" 或 "ly^3"
立方米 "m3" 或 "m^3"
立方英里 "mi3" 或 "mi^3"
立方码 "yd3" 或 "yd^3"
立方海里 "Nmi3" 或 "Nmi^3"
立方皮卡 "Picapt3", "Picapt3", "Pica3" 或 "Pica3"
总登记吨 "GRT" ("regton")
计量吨(货运吨) "MTON"
速度单位类型 可转换单位
米/秒 "m/s" 或 "m/sec"
海里 "admkn"
"kn"
每小时米 "m/h" 或 "m/hr"
英里每小时 "mph"
面积单位类型 可转换单位
国际英亩 "uk_acre"
美国 调查/法规英亩 "us_acre"
平方埃 "ang2" 或 “ang^2"
公亩 "ar"
平方英尺 "ft2" or "ft^2"
公顷 "ha"
平方英寸 "in2" 或 "in^2"
平方光年 "ly2" 或 "ly^2"
平方米 "m2" 或 "m^2"
摩根 "Morgen"
平方英里 "mi2" 或 "mi^2"
平方海里 "Nmi2" 或 "Nmi^2"
方形皮卡 "Picapt2", "Pica2", "Pica2" 或 "Picapt2"
平方码 "yd2" 或 "yd^2"

下表列出了可以在任何度量from_unit或to_unit之前添加的缩写单位前缀。

前缀 乘数 缩写
yotta 1.00E+24 "Y"
zetta 1.00E+21 "Z"
exa 1.00E+18 "E"
peta 1.00E+15 "P"
tera 1.00E+12 "T"
giga 1.00E+09 "G"
mega 1.00E+06 "M"
kilo 1.00E+03 "k"
hecto 1.00E+02 "h"
dekao 1.00E+01 "e"
deci 1.00E-01 "d"
centi 1.00E-02 "c"
milli 1.00E-03 "m"
micro 1.00E-06 "u"
nano 1.00E-09 "n"
pico 1.00E-12 "p"
femto 1.00E-15 "f"
atto 1.00E-18 "a"
zepto 1.00E-21 "z"
yocto 1.00E-24 "y"
二进制前缀 前缀值 缩写 衍生自
yobi 2^80 = 1 208 925 819 614 629 174 706 176 "Yi" yotta
zebi 2^70 = 1 180 591 620 717 411 303 424 "Zi" zetta
exbi 2^60 = 1 152 921 504 606 846 976 "Ei" exa
pebi 2^50 = 1 125 899 906 842 624 "Pi" peta
tebi 2^40 = 1 099 511 627 776 "Ti" tera
gibi 2^30 = 1 073 741 824 "Gi" giga
mebi 2^20 = 1 048 576 "Mi" mega
kibi 2^10 = 1024 "ki" kilo

数据类型

接受数值和字符串数据。返回数值数据。

示例

CONVERT(68,"F","C")