# CONVERT

Converts a numeric value to a different unit of measure.

### Sample Usage

CONVERT(2000,"m","km")
CONVERT(68,"F","C")

### Syntax

CONVERT(number, from_unit, to_unit)

• number - The numeric value to convert.
• from_unit - The unit before conversion.
• to_unit - The unit after conversion.

### Examples

CONVERT(2000,"m","km") converts 2000 meters into kilometers, and returns the value 2.
CONVERT(68,"F","C") converts 68 degrees Fahrenheit to Celsius, and returns the value 20.

### Notes

• If the unit does not exist, CONVERT returns the #N/A error value.
• If the units are in different groups, CONVERT returns the #N/A error value.
• Unit names and prefixes are case-sensitive.
• The following list outlines the units by category:
• Weight - u, grain, g, ozm, lbm, stone, sg, cwt, uk_cwt, ton, uk_ton
• Distance - ang, Picapt, pica, in, ft, yd, m, ell, mi, survey_mi Nmi, ly, parsec
• Time - sec, min, hr, day, yr
• Pressure - Pa, mmHg, Torr, psi, atm
• Force - dyn, pond, N, lbf
• Energy - eV, e, J, flb, c, cal, BTU, Wh, HPh
• Power - W, PS, HP
• Magnetism - ga, T
• Temperature - C, F, K, Rank, Reau
• Volume - ang^3, Picapt^3, tsp, tspm, tbs, in^3, oz, cup, pt, uk_pt, qt, l, uk_qt, gal, uk_gal, ft^3, bushel, barrel, yd^3, m^3, MTON, GRT, mi^3, Nmi^3, ly^3
• Area - ang^2, Picapt^2, in^2, ft^2, yd^2, m^2,ar, Morgen,uk_acre, us_acre, ha, mi^2, Nmi^2, ly^2
• Information - bit, byte
• Speed - m/hr, mph, kn, admkn, m/s