| Id| A | B | C | D | | 1|Formula |Result | Test |Description | | | 2| {=CONVERT(1,"lbm","kg") 0.45359237}| 0.4535924| {=RC[-1]=RC[-2] TRUE} |Converts 1 pound mass to kilograms. | | | 3| {=CONVERT(68,"F","C") 20}| 20| {=RC[-1]=RC[-2] TRUE} |Converts 68 degrees Fahrenheit to Celsius. | | | 4| {=CONVERT(2.5,"ft","sec") #N/A}| #N/A | {=RC[-1]=RC[-2] TRUE} |Data types are not the same, so an error is returned. | | | 5| {=CONVERT(CONVERT(100,"ft","m"),"ft","m") 9.290304}| 9.290304| {=RC[-1]=RC[-2] TRUE} |Converts 100 square feet into square meters. | | CONVERT function Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. Syntax: CONVERT(number,from_unit,to_unit) Number: is the value in from_units to convert. From_unit: is the units for number. To_unit: is the units for the result. CONVERT accepts the following text values (in quotation marks) for from_unit and to_unit. |{b Weight and mass} |{b From_unit or to_unit} | |Gram |"g" | |Slug |"sg" | |Pound mass (avoirdupois) |"lbm" | |U (atomic mass unit) |"u" | |Ounce mass (avoirdupois) |"ozm" | |Grain |"grain" | |U.S. (short) hundredweight |"cwt" or "shweight" | |Imperial hundredweight |"uk_cwt" or "lcwt" ("hweight") | |Stone |"stone" | |Ton |"ton" | |Imperial ton |"uk_ton" or "LTON" ("brton") | |{b Distance} |{b From_unit or to_unit} | |Meter |"m" | |Statute mile |"mi" | |Nautical mile |"Nmi" | |Inch |"in" | |Foot |"ft" | |Yard |"yd" | |Angstrom |"ang" | |Ell |"ell" | |Light-year |"ly" | |Parsec |"parsec" or "pc" | |Pica (1/72 inch) |"Picapt" or "Pica" | |Pica (1/6 inch) |"pica" | |U.S survey mile (statute mile) |"survey_mi" | |{b Time} |{b From_unit or to_unit} | |Year |"yr" | |Day |"day" or "d" | |Hour |"hr" | |Minute |"mn" or "min" | |Second |"sec" or "s" | |{b Pressure} |{b From_unit or to_unit} | |Pascal |"Pa" (or "p") | |Atmosphere |"atm" (or "at") | |mm of Mercury |"mmHg" | |PSI |"psi" | |Torr |"Torr" | |{b Force} |{b From_unit or to_unit} | |Newton |"N" | |Dyne |"dyn" (or "dy") | |Pound force |"lbf" | |Pond |"pond" | |{b Energy} |{b From_unit or to_unit} | |Joule |"J" | |Erg |"e" | |Thermodynamic calorie |"c" | |IT calorie |"cal" | |Electron volt |"eV" (or "ev") | |Horsepower-hour |"HPh" (or "hh") | |Watt-hour |"Wh" (or "wh") | |Foot-pound |"flb" | |BTU |"BTU" (or "btu") | |{b Power} |{b From_unit or to_unit} | |Horsepower |"HP" (or "h") | |Pferdestärke |"PS" | |Watt |"W" (or "w") | |{b Magnetism} |{b From_unit or to_unit} | |Tesla |"T" | |Gauss |"ga" | |{b Temperature} |{b From_unit or to_unit} | |Degree Celsius |"C" (or "cel") | |Degree Fahrenheit |"F" (or "fah") | |Kelvin |"K" (or "kel") | |Degrees Rankine |"Rank" | |Degrees Réaumur |"Reau" | |{b Volume (or l} {b iquid measure} {b )} |{b From_unit or to_unit} | |Teaspoon |"tsp" | |Modern teaspoon |"tspm" | |Tablespoon |"tbs" | |Fluid ounce |"oz" | |Cup |"cup" | |U.S. pint |"pt" (or "us_pt") | |U.K. pint |"uk_pt" | |Quart |"qt" | |Imperial quart (U.K.) |"uk_qt" | |Gallon |"gal" | |Imperial gallon (U.K.) |"uk_gal" | |Liter |"l" or "L" ("lt") | |Cubic angstrom |"ang3" or "ang^3" | |U.S. oil barrel |"barrel" | |U.S. bushel |"bushel" | |Cubic feet |"ft3" or "ft^3" | |Cubic inch |"in3" or "in^3" | |Cubic light-year |"ly3" or "ly^3" | |Cubic meter |"m3" or "m^3" | |Cubic Mile |"mi3" or "mi^3" | |Cubic yard |"yd3" or "yd^3" | |Cubic nautical mile |"Nmi3" or "Nmi^3" | |Cubic Pica |"Picapt3", "Picapt^3", "Pica3" or "Pica^3" | |Gross Registered Ton |"GRT" ("regton") | |Measurement ton (freight ton) |"MTON" | |{b Area} |{b From_unit or to_unit} | |International acre |"uk_acre" | |U.S. survey/statute acre |"us_acre" | |Square angstrom |"ang2" or “ang^2" | |Are |"ar" | |Square feet |"ft2" or "ft^2" | |Hectare |"ha" | |Square inches |"in2" or "in^2" | |Square light-year |"ly2" or "ly^2" | |Square meters |"m2" or "m^2" | |Morgen |"Morgen" | |Square miles |"mi2" or "mi^2" | |Square nautical miles |"Nmi2" or "Nmi^2" | |Square Pica |"Picapt2", "Pica2", "Pica^2" or "Picapt^2" | |Square yards |"yd2" or "yd^2" | |{b Information} |{b From_unit or to_unit} | |Bit |"bit" | |Byte |"byte" | |{b Speed} |{b From_unit or to_unit} | |Admiralty knot |"admkn" | |Knot |"kn" | |Meters per hour |"m/h" or "m/hr" | |Meters per second |"m/s" or "m/sec" | |Miles per hour |"mph" | The following abbreviated unit prefixes can be prepended to any metric from_unit or to_unit. |{b Prefix} |{b Multiplier} |{b Abbr.} | |yotta |1E+24 |"Y" | |zetta |1E+21 |"Z" | |exa |1E+18 |"E" | |peta |1E+15 |"P" | |tera |1E+12 |"T" | |giga |1E+09 |"G" | |mega |1E+06 |"M" | |kilo |1E+03 |"k" | |hecto |1E+02 |"h" | |dekao |1E+01 |"da", "e" | |deci |1E-01 |"d" | |centi |1E-02 |"c" | |milli |1E-03 |"m" | |micro |1E-06 |"u" | |nano |1E-09 |"n" | |pico |1E-12 |"p" | |femto |1E-15 |"f" | |atto |1E-18 |"a" | |zepto |1E-21 |"z" | |yocto |1E-24 |"y" | |{b Binary Prefix} |{b Prefix Value} |{b Abbreviation} |{b Derived from} | |yobi |2^80 = 1 208 925 819 614 629 174 706 176 |"Yi" |yotta | |zebi |2^70 = 1 180 591 620 717 411 303 424 |"Zi" |zetta | |exbi |2^60 = 1 152 921 504 606 846 976 |"Ei" |exa | |pebi |2^50 = 1 125 899 906 842 624 |"Pi" |peta | |tebi |2^40 = 1 099 511 627 776 |"Ti" |tera | |gibi |2^30 = 1 073 741 824 |"Gi" |giga | |mebi |2^20 = 1 048 576 |"Mi" |mega | |kibi |2^10 = 1024 |"ki" |kilo | Remarks: If the input data types are incorrect, CONVERT returns the #VALUE! error value. If the unit does not exist, CONVERT returns the #N/A error value. If the unit does not support a binary prefix, 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. |Expression |Result | Test |Comment | {=CONVERT(1,"ft","in") 12}| 12| {=RC[-1]=RC[-2] TRUE} |1 foot is 12 inches. Conversion between units might involve an intermediate SI unit in some implementations, and such round-off error is considered acceptable. | {=CONVERT(1,"in","cm") 2.54}| 2.54| {=RC[-1]=RC[-2] TRUE} |1 inch is 2.54 cm. The result is exact, because this needs to be represented as accurately as the underlying numerical model permits | {=CONVERT(5,"m","mm") 5000}| 5000| {=RC[-1]=RC[-2] TRUE} |5 meters is 5000 millimeters | {=CONVERT(100,"C","F") 212}| 212| {=RC[-1]=RC[-2] TRUE} |212 degrees F is 100 degrees C. Note that this is not simply a multiplicative relationship. Since internally this is (100/5*9+32), where 100/5 is exactly 20, this result needs to be exact even on floating-point implementations | {=CONVERT(2,"Ym","Zm") 2000}| 2000| {=RC[-1]=RC[-2] TRUE} |Must support Y and Z prefixes. | {=CONVERT(20,"F","m") #N/A}| #N/A | {=RC[-1]=RC[-2] TRUE} |Different groups produce an error. | {=CONVERT(1000,"qt","l") 946.352946}| 946.3529| {=RC[-1]=RC[-2] TRUE} |Quart is U.S. customary, liquid measure | {=CONVERT(1000,"tbs","l") 14.78676478125}| 14.786765| {=RC[-1]=RC[-2] TRUE} |Tablespoon uses U.S. customary historic definition – note that there are many other definitions | {=CONVERT(1000,"tsp","l") 4.92892159375}| 4.928922| {=RC[-1]=RC[-2] TRUE} |Teaspoon uses U.S. customary historic definition – note that there are many other definitions | {=CONVERT(1,"das","sec") 10}| 10| {=RC[-1]=RC[-2] TRUE} |Does it support both "s" and "sec" for second? Does it support "da" as the SI standard deka prefix? | {=CONVERT(1,"ar","m^2") 100}| 100| {=RC[-1]=RC[-2] TRUE} |A hectare (ar) is 100 square meters. | {=CONVERT(1,"cal","J") 4.18679483986412}| 4.186795| {=RC[-1]=RC[-2] TRUE} |"cal" is an International Table (IT) calorie, 4.1868 J. | {=CONVERT(1,"lbf","N") 4.44822199318031}| 4.448222| {=RC[-1]=RC[-2] TRUE} |Converting pound-force to Newtons | {=CONVERT(1,"HP","W") 745.701}| 745.701| {=RC[-1]=RC[-2] TRUE} |Horsepower to Watts | {=CONVERT(1,"Mibyte","bit") 8388608}| 8388608| {=RC[-1]=RC[-2] TRUE} |Converts bytes to bits, and tests binary prefixes | {=CONVERT(1,"T","ga") 10000}| 10000| {=RC[-1]=RC[-2] TRUE} |Tesla to Gauss | {=CONVERT(1,"lbm","g") 453.59237}| 453.59237| {=RC[-1]=RC[-2] TRUE} |International pound mass (avoirdupois) to grams. (This is actually exact.) | {=CONVERT(1,"uk_ton","lbm") 2240}| 2240| {=RC[-1]=RC[-2] TRUE} |Imperial ton, aka "long ton", "deadweight ton", or "weight ton", is 2240 lbm. | {=CONVERT(1,"psi","Pa") 6894.75728034313}| 6894.757| {=RC[-1]=RC[-2] TRUE} |Pounds per square inch to Pascals. | {=CONVERT(60,"mph","km/h") 96.56064}| 96.56064| {=RC[-1]=RC[-2] TRUE} |Miles per hour to kilometers per hour. | {=CONVERT(1,"day","s") 86400}| 86400| {=RC[-1]=RC[-2] TRUE} |Day to seconds. Note: This test uses the international standard abbreviation for second (s), not the abbreviation traditionally used in spreadsheets (sec); both "s" and "sec" must be supported. | {=CONVERT(1,"qt","L") 0.946352946}| 0.946352946| {=RC[-1]=RC[-2] TRUE} |Quart (U.S. customary liquid measure) to liter. This is 0.946352946 liters. This is a Sample *.STX File. (C) http://Spoc-Web.com