Energy Unit Converter in Excel
6.585141E+012
Add-in Formula
=PO.UnitConverter(1, "Btu[IT]", "GeV")
Excel Lambda
=LAMBDA(x,
LET(
ratio, 6585141282378.59,
x * ratio
)
)(1)
Category Lambda
=LAMBDA(x, from, to,
LET(
f, SWITCH(from,
"J", 1,
"kJ", 1000,
"mJ", 0.001,
"MJ", 1000000,
"1E6 Btu[IT]", 1055055852.62,
"Btu[IT]", 1055.05585262,
"Btu[UK]", 1055.05585257348,
"Btu[th]", 1054.35026448889,
"kW.h", 3600000,
"MW.h", 3600000000,
"GW.h", 3600000000000,
"GeV", 1.602176487E-10,
"MeV", 1.602176487E-13,
"keV", 1.602176487E-16,
"meV", 1.602176487E-22),
t, SWITCH(to,
"J", 1,
"kJ", 1000,
"mJ", 0.001,
"MJ", 1000000,
"1E6 Btu[IT]", 1055055852.62,
"Btu[IT]", 1055.05585262,
"Btu[UK]", 1055.05585257348,
"Btu[th]", 1054.35026448889,
"kW.h", 3600000,
"MW.h", 3600000000,
"GW.h", 3600000000000,
"GeV", 1.602176487E-10,
"MeV", 1.602176487E-13,
"keV", 1.602176487E-16,
"meV", 1.602176487E-22),
x * f / t
)
)(1, "Btu[IT]", "GeV")
How to save as a reusable Excel function
LAMBDA is a built-in Excel feature (Microsoft 365) that lets you create custom functions without VBA. The formulas above work as-is when pasted into a cell.
To save a LAMBDA as a reusable named function:
- Go to Formulas → Name Manager → New
- Enter a name, e.g.
ConvertEnergy - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =ConvertEnergy(1, "Btu[IT]", "GeV")
anywhere in your workbook — no add-in required.
Conversion Factors (base: J)
| Unit | Name | Factor |
|---|---|---|
| J | joule | 1 |
| kJ | kilojoule | 1000 |
| mJ | millijoule | 0.001 |
| MJ | megajoule | 1000000 |
| 1E6 Btu[IT] | million BTU | 1055055852.62 |
| Btu[IT] | British thermal unit | 1055.05585262 |
| Btu[UK] | United Kingdom British thermal unit | 1055.05585257348 |
| Btu[th] | thermochemical British thermal unit | 1054.35026448889 |
| kW.h | kilowatt hour | 3600000 |
| MW.h | megawatt hour | 3600000000 |
| GW.h | gigawatt hour | 3600000000000 |
| GeV | gigaelectronvolt | 1.602176487E-10 |
| MeV | megaelectronvolt | 1.602176487E-13 |
| keV | kiloelectronvolt | 1.602176487E-16 |
| meV | millielectronvolt | 1.602176487E-22 |