CONVERT

Converts a numeric value to a different unit of measure.

Sample Usage

CONVERT(5.1, "g", "kg")

CONVERT(32, "C", "F")

CONVERT(35.7, "in^2", "m^2")

CONVERT(A1, A2, A3)

Syntax

CONVERT(value, start_unit, end_unit)

  • value - the numeric value in start_unit to convert to end_unit

  • start_unit - The starting unit, the unit currently assigned to value .

  • end_unit - The unit of measure into which to convert value.

Notes

  • The following list outlines the available unit conversions 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

     

  • The use of CONVERT between two different categories of start_unit and end_unit will result in an error. For example, CONVERT(13.2,"ft","C") would result in an error as a result of an attempted conversion from distance units to temperature units.

See Also

DATE: Converts a year, month, and day into a date.

DATEVALUE: Converts a provided date string in a known format to a date value.

TIME: Converts an hour, minute, and second into a time.

TIMEVALUE: Returns the fraction of a 24-hour day the time represents.

Examples

The following example shows CONVERT between different sample start_unit and end_unit arguments.

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu