        [{"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"}]}]

SpreadJS 概述
快速开始
框架中开发
最佳实践
产品特性
表格设计器
移动端与触控
公式引用
- 公式概述
- 公式函数
  - 条形码
  - 兼容性函数
  - 数据库函数
  - 日期和时间函数
  - 工程函数
    - BESSELI
    - BESSELJ
    - BESSELK
    - BESSELY
    - BIN2DEC
    - BIN2HEX
    - BIN2OCT
    - BITAND
    - BITLSHIFT
    - BITOR
    - BITRSHIFT
    - BITXOR
    - COMPLEX
    - CONVERT
    - DEC2BIN
    - DEC2HEX
    - DEC2OCT
    - DELTA
    - ERF
    - ERF.PRECISE
    - ERFC
    - ERFC.PRECISE
    - GESTEP
    - HEX2BIN
    - HEX2DEC
    - HEX2OCT
    - IMABS
    - IMAGINARY
    - IMARGUMENT
    - IMCONJUGATE
    - IMCOS
    - IMCOSH
    - IMCOT
    - IMCSC
    - IMCSCH
    - IMDIV
    - IMEXP
    - IMLN
    - IMLOG10
    - IMLOG2
    - IMPOWER
    - IMPRODUCT
    - IMREAL
    - IMSEC
    - IMSECH
    - IMSIN
    - IMSINH
    - IMSQRT
    - IMSUB
    - IMSUM
    - IMTAN
    - OCT2BIN
    - OCT2DEC
    - OCT2HEX
  - 财务函数
  - 信息函数
  - 逻辑函数
  - 查找与引用函数
  - 数学与三角函数
  - 统计函数
  - 迷你图
  - 文本函数
  - Web函数
  - 正则函数
  - 其他函数
导入导出参考
常用事件
API 索引
常见问题
发布说明

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", "Picapt^{3", "Pica3" 或 "Pica}3"
总登记吨	"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", "Pica^{2" 或 "Picapt}2"
平方码	"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")