Convert measurements between any units — metres to feet, Celsius to Fahrenheit, kg to pounds — with one formula.
CONVERT transforms a number from one measurement unit to another. It covers length, weight, temperature, time, pressure, energy, speed, and more — all using standardised unit abbreviation strings.
CONVERT(number, from_unit, to_unit)| Argument | What it means |
|---|---|
| number required | The value to convert. |
| from_unit required | The unit the number is currently in. Must be a recognised text string. |
| to_unit required | The unit to convert to. Must be in the same category as from_unit. |
| Category | From / To examples |
|---|---|
| Length | "m" metres, "ft" feet, "in" inches, "km" kilometres, "mi" miles |
| Weight | "kg" kilograms, "lbm" pounds, "g" grams, "oz" ounces |
| Temperature | "C" Celsius, "F" Fahrenheit, "K" Kelvin |
| Time | "day" days, "hr" hours, "mn" minutes, "sec" seconds |
| Speed | "m/s" metres/sec, "mph" miles/hour, "kn" knots |
=CONVERT(100, "km", "mi")
-- 100 kilometres to miles → 62.14
=CONVERT(A2, "C", "F")
-- Celsius in A2 to Fahrenheit
=CONVERT(5, "lbm", "kg")
-- 5 pounds to kilograms → 2.27
=CONVERT(1, "day", "hr")
-- 1 day to hours → 24"C" is Celsius but "c" is not. "m" is metres but "M" is not. If CONVERT returns #N/A, the most likely cause is a capitalisation error in the unit string.
Type it in a live spreadsheet, get instant feedback. No videos, no downloads.
Start practising free →