Convert units in Excel
Excel has two ways to convert a unit, and they answer different questions.
CONVERT
CONVERT is built into Excel. It knows a fixed list of codes, such as kPa and psi. It does not know bar, centipoise or a newton metre. Codes are case-sensitive, and a prefix multiplies the unit as written.
CONVERT unit codesLAMBDA
A LAMBDA uses the factors from this site, for every unit in a quantity, including the ones CONVERT skips. You can save it as a named function. Microsoft 365, with no VBA.
How to write and save a LAMBDAThis site does not publish an Excel add-in. For API gravity and oilfield rates, see Petroleum Office.
Quantities
LAMBDA library- Pressure 44 units · ConvertPressure
- Dynamic Viscosity 21 units · ConvertDynamicViscosity
- Electric Current 13 units · ConvertElectricCurrent
- Moment Of Force 12 units · ConvertMomentOfForce
- Thermodynamic Temperature 5 units · ConvertThermodynamicTemperature
- Length 84 units · ConvertLength
- Force 27 units · ConvertForce
- Energy 56 units · ConvertEnergy
- Volume 68 units · ConvertVolume
- Second Moment Of Area 3 units · ConvertSecondMomentOfArea
- Electric Resistance 13 units · ConvertElectricResistance
Google Sheets
Google Sheets has CONVERT and many of the same codes, and it has LAMBDA. Named functions are created under Data > Named functions, not Formulas > Name Manager. A code that works in Excel can return #N/A in Sheets, so try a known value before you rely on it.