SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
    - 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
  - Financial Functions
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
  - Web Functions
  - Other Functions
Import and Export Reference
Frequently Used Events
API Documentation
Release Notes

CONVERT

This function converts a number from one measurement system to its equivalent in another measurement system.

Syntax

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

Arguments

This function has these arguments:

Argument	Description
number	Numeric value to convert
from-unit	Convertible units (see table below) of numeric value to convert
to-unit	Convertible units (see table below) of the desired result

Remarks

In this context, a measurement system is a set of units for different types of measurements. This function converts a number with one set of units to a number in a different set of units.

An error value is returned if the convertible units ( from-unit and to-unit ) are invalid or are from different categories of unit types (different tables below).

The following tables list the convertible units by their unit type:

Weight and Mass Unit Type	Convertible Units
Gram	"g"
Slug	"sg"
Pound Mass	"lbm"
U	"u"
Ounce Mass	"ozm"
Grain	"grain"
U.S. (short) hundredweight	"cwt" or "shweight"
Imperial hundredweight	"uk_cwt" , "lcwt" or "hweight"
Stone	"stone"
Ton	"ton"
Imperial ton	"uk_ton" , "LTON" or "brton"

Distance Unit Type	Convertible Units
Meter	"m"
Statute mile	"mi"
Nautical mile	"Nmi"
Inch	"in"
Foot	"ft"
Yard	"yd"
Angstrom	"ang"
Ell	"ell"
Light-year	"ly"
Parsec	"parsec" or "pc"
Pica (1/72 inch)	"Pica"
Pica (1/6 inch)	"pica"
U.S survey mile (statute mile)	"survey_mi"

Time Unit Type	Convertible Units
Year	"yr"
Day	"day"
Hour	"hr"
Minute	"mn"
Second	"sec"

Pressure Unit Type	Convertible Units
Pascal	"Pa"
Atmosphere	"atm"
mm of Mercury	"mmHg"
PSI	"psi"
Torr	"torr"

Force Unit Type	Convertible Units
Newton	"N"
Dyne	"dyn"
Pound force	"lbf"
Pond	"pond"

Energy Unit Type	Convertible Units
Joule	"J"
Erg	"e"
Thermodynamic calorie	"c"
IT calorie	"cal"
Electron volt	"eV"
Horsepower-hour	"Hph"
Watt-hour	"Wh"
Foot-pound	"flb"
BTU	"BTU"

Power Unit Type	Convertible Units
Horsepower	"HP"
Pferdestärke	"PS"
Watt	"W" or "w"

Magnetism Unit Type	Convertible Units
Tesla	"T"
Gauss	"ga"

Temperature Unit Type	Convertible Units
Degree Celsius	"C"
Degree Fahrenheit	"F"
Degree Kelvin	"K"
Degrees Rankine	"Rank"
Degrees Réaumur	"Reau"

Liquid Measure Unit Type	Convertible Units
Teaspoon	"tsp"
Modern teaspoon	"tspm"
Tablespoon	"tbs"
Fluid ounce	"oz"
Cup	"cup"
U.S. pint	"pt"
U.K. pint	"uk_pt"
Quart	"qt"
Imperial quart (U.K.)	"uk_qt"
Gallon	"gal"
Imperial gallon (U.K.)	"uk_gal"
Liter	"l"
Cubic angstrom	"ang3" or "ang^3"
U.S. oil barrel	"barrel"
U.S. bushel	"bushel"
Cubic feet	"ft3" or "ft^3"
Cubic inch	"in3" or "in^3"
Cubic light-year	"ly3" or "ly^3"
Cubic meter	"m3" or "m^3"
Cubic Mile	"mi3" or "mi^3"
Cubic yard	"yd3" or "yd^3"
Cubic nautical mile	"Nmi3" or "Nmi^3"
Cubic Pica	"Picapt3", "Picapt^3", "Pica3" or "Pica^3"
Gross Registered Ton	"GRT" ("regton")
Measurement ton (freight ton)	"MTON"

Speed Unit Type	Convertible Units
Meters per second	"m/s" or "m/sec"
Admiralty knot	"admkn"
Knot	"kn"
Meters per hour	"m/h" or "m/hr"
Miles per hour	"mph"

Area Unit Type	Convertible Units
International acre	"uk_acre"
U.S. survey/statute acre	"us_acre"
Square angstrom	"ang2" or “ang^2"
Are	"ar"
Square feet	"ft2" or "ft^2"
Hectare	"ha"
Square inches	"in2" or "in^2"
Square light-year	"ly2" or "ly^2"
Square meters	"m2" or "m^2"
Morgen	"Morgen"
Square miles	"mi2" or "mi^2"
Square nautical miles	"Nmi2" or "Nmi^2"
Square Pica	"Picapt2", "Pica2", "Pica^2" or "Picapt^2"
Square yards	"yd2" or "yd^2"

The following tables list the abbreviated unit prefixes that can be prepended to any metric from_unit or to_unit.

Prefix	Multiplier	Abbreviation
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"

Binary Prefix	Prefix Value	Abbreviation	Derived From
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

Data Types

Accepts numeric and string data. Returns numeric data.

Examples

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