CONVERT

Definition of 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 provided year, month, and day into a date.

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

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

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

In order to use the CONVERT formula, start with your edited Excellentable

Then type in the CONVERT Formula in the area you would like to display the outcome:

Type in the complete CONVERT formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter.