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. 

	A	B	C
1	State	Revenue	Population	Total area in mi2	Land area in mi2	Water area in mi2
2	Alabama	169.65	4833722
3	Alaska	169.64	735132
4	Arizona	2.98	6626624
5	Arkansas	-2.98	2959373
6	California	150.3	38332521
7	Colorado	150.25	5268367
8	Connecticut	131.56	3596080
9	Delaware	-127.89	925749
10	Florida	97.34	19552860
11	Georgia	68	9992167
12	Hawaii	5.6	1404054
13	Idaho	9.99	1612136
14
15		20

	D	E	F
1

House seat(s)

52,420 (135,767)

50,645 (131,170)

1,775 (4,597)

665,384 (1,723,337)

570,641 (1,477,950)

94,743 (245,383)

113,990 (295,233)

113,594 (294,207)

396 (1,026)

53,179 (137,733)

52,035 (134,770)

1,143 (2,960)

163,695 (423,968)

155,779 (403,466)

7,916 (20,502)

104,094 (269,602)

103,642 (268,432)

452 (1,171)

5,543 (14,356)

4,842 (12,541)

701 (1,816)

2,489 (6,446)

1,949 (5,048)

540 (1,399)

65,758 (170,312)

53,625 (138,888)

12,133 (31,424)

59,425 (153,910)

57,513 (148,958)

1,912 (4,950)

10,932 (28,314)

6,423 (16,635)

4,509 (11,678)

83,569 (216,443)

82,643 (214,044)

926 (2,398)

7

1

9

4

53

7

5

1

27

14

2

2