Arte SheetsLearn. Try. Understand.

Engineering

CONVERT function: translate weight, distance, and temperature units accurately

Convert engineering and logistics measurements between metric and imperial unit codes with CONVERT.

Open spreadsheet ↗

Standardized unit conversion without manual constants

CONVERT(number, from_unit, to_unit) translates values across mass ("kg", "g", "lbm", "ozm"), length ("m", "km", "in", "ft", "mi"), temperature ("C", "F", "K"), time ("hr", "min", "sec"), and volume ("l", "gal", "ml").

Incompatible unit categories (such as converting "kg" to "m") return #N/A.

=ROUND(CONVERT(A2, B2, C2), 4)

Try the example

Use the original values or change them to test your understanding.