# 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.

`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.

### 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
169.64
735132
4
Arizona
2.98
6626624
5
Arkansas
-2.98
2959373
6
California
150.3
38332521
7
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)
2
52,420 (135,767)
50,645 (131,170)
1,775 (4,597)
3
665,384 (1,723,337)
570,641 (1,477,950)
94,743 (245,383)
4
113,990 (295,233)
113,594 (294,207)
396 (1,026)
5
53,179 (137,733)
52,035 (134,770)
1,143 (2,960)
6
163,695 (423,968)
155,779 (403,466)
7,916 (20,502)
7
104,094 (269,602)
103,642 (268,432)
452 (1,171)
8
5,543 (14,356)
4,842 (12,541)
701 (1,816)
9
2,489 (6,446)
1,949 (5,048)
540 (1,399)
10
65,758 (170,312)
53,625 (138,888)
12,133 (31,424)
11
59,425 (153,910)
57,513 (148,958)
1,912 (4,950)
12
10,932 (28,314)
6,423 (16,635)
4,509 (11,678)
13
83,569 (216,443)
82,643 (214,044)
926 (2,398)
14
15
G
1
2
7
3
1
4
9
5
4
6
53
7
7
8
5
9
1
10
27
11
14
12
2
13
2
14
15

JavaScript errors detected