Excel LAMBDA library
Copy a function and save it in Name Manager under the name shown. The quantity page has the live converter, the CONVERT formula where Excel has codes, and the factor table. These are the same functions.
ConvertPressure
Pressure, 44 units. Open the converter
=ConvertPressure(1, "bar", "psi")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"Pa",1,"0.01 lbf/ft2",0.4788025898033583,"EPa",1000000000000000000,"GPa",1000000000,"MPa",1000000,"Mpsi",6894757293.168363,"N/m2",1,"N/mm2",1000000,"TPa",1000000000000,"at",98066.5,"atm",101325,"bar",100000,"cPa",0.01,"cmH2O[4degC]",98.0638,"dPa",0.1,"dyne/cm2",0.1,"fPa",1E-15,"hbar",10000000,"inH2O[39degF]",249.082,"inH2O[60degF]",248.84,"inHg[32degF]",3386.38,"inHg[60degF]",3376.85,"kN/m2",1000,"kPa",1000,"kgf/cm2",98066.5,"kgf/m2",9.80665,"kgf/mm2",9806650,"kpsi",6894757.293168361,"lbf/ft2",47.88025898033584,"mPa",0.001,"mbar",100,"mmHg[0degC]",133.322,"nPa",1E-9,"pPa",1E-12,"psi",6894.757293168361,"tonf[UK]/ft2",107251.7801159523,"tonf[US]/ft2",95760.51796067167,"tonf[US]/in2",13789514.586336723,"torr",133.32236842105263,"uPa",0.000001,"ubar",0.1,"umHg[0degC]",0.133322,"upsi",0.006894757293168362,"hPa",100),fromShift,SWITCH(from_unit,"Pa",0,"0.01 lbf/ft2",0,"EPa",0,"GPa",0,"MPa",0,"Mpsi",0,"N/m2",0,"N/mm2",0,"TPa",0,"at",0,"atm",0,"bar",0,"cPa",0,"cmH2O[4degC]",0,"dPa",0,"dyne/cm2",0,"fPa",0,"hbar",0,"inH2O[39degF]",0,"inH2O[60degF]",0,"inHg[32degF]",0,"inHg[60degF]",0,"kN/m2",0,"kPa",0,"kgf/cm2",0,"kgf/m2",0,"kgf/mm2",0,"kpsi",0,"lbf/ft2",0,"mPa",0,"mbar",0,"mmHg[0degC]",0,"nPa",0,"pPa",0,"psi",0,"tonf[UK]/ft2",0,"tonf[US]/ft2",0,"tonf[US]/in2",0,"torr",0,"uPa",0,"ubar",0,"umHg[0degC]",0,"upsi",0,"hPa",0),toFactor,SWITCH(to_unit,"Pa",1,"0.01 lbf/ft2",0.4788025898033583,"EPa",1000000000000000000,"GPa",1000000000,"MPa",1000000,"Mpsi",6894757293.168363,"N/m2",1,"N/mm2",1000000,"TPa",1000000000000,"at",98066.5,"atm",101325,"bar",100000,"cPa",0.01,"cmH2O[4degC]",98.0638,"dPa",0.1,"dyne/cm2",0.1,"fPa",1E-15,"hbar",10000000,"inH2O[39degF]",249.082,"inH2O[60degF]",248.84,"inHg[32degF]",3386.38,"inHg[60degF]",3376.85,"kN/m2",1000,"kPa",1000,"kgf/cm2",98066.5,"kgf/m2",9.80665,"kgf/mm2",9806650,"kpsi",6894757.293168361,"lbf/ft2",47.88025898033584,"mPa",0.001,"mbar",100,"mmHg[0degC]",133.322,"nPa",1E-9,"pPa",1E-12,"psi",6894.757293168361,"tonf[UK]/ft2",107251.7801159523,"tonf[US]/ft2",95760.51796067167,"tonf[US]/in2",13789514.586336723,"torr",133.32236842105263,"uPa",0.000001,"ubar",0.1,"umHg[0degC]",0.133322,"upsi",0.006894757293168362,"hPa",100),toShift,SWITCH(to_unit,"Pa",0,"0.01 lbf/ft2",0,"EPa",0,"GPa",0,"MPa",0,"Mpsi",0,"N/m2",0,"N/mm2",0,"TPa",0,"at",0,"atm",0,"bar",0,"cPa",0,"cmH2O[4degC]",0,"dPa",0,"dyne/cm2",0,"fPa",0,"hbar",0,"inH2O[39degF]",0,"inH2O[60degF]",0,"inHg[32degF]",0,"inHg[60degF]",0,"kN/m2",0,"kPa",0,"kgf/cm2",0,"kgf/m2",0,"kgf/mm2",0,"kpsi",0,"lbf/ft2",0,"mPa",0,"mbar",0,"mmHg[0degC]",0,"nPa",0,"pPa",0,"psi",0,"tonf[UK]/ft2",0,"tonf[US]/ft2",0,"tonf[US]/in2",0,"torr",0,"uPa",0,"ubar",0,"umHg[0degC]",0,"upsi",0,"hPa",0),(value*fromFactor+fromShift-toShift)/toFactor))
ConvertDynamicViscosity
Dynamic Viscosity, 21 units. Open the converter
=ConvertDynamicViscosity(1, "cP", "Pa.s")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"Pa.s",1,"EP",100000000000000000,"GP",100000000,"MP",100000,"N.s/m2",1,"P",0.1,"TP",100000000000,"cP",0.001,"dP",0.01,"dyne.s/cm2",0.1,"fP",1E-16,"kP",100,"kgf.s/m2",9.80665,"lbf.s/ft2",47.88025898033584,"lbf.s/in2",6894.757293168361,"mP",0.0001,"mPa.s",0.001,"nP",1E-10,"pP",1E-13,"psi.s",6894.757293168361,"uP",1E-7),fromShift,SWITCH(from_unit,"Pa.s",0,"EP",0,"GP",0,"MP",0,"N.s/m2",0,"P",0,"TP",0,"cP",0,"dP",0,"dyne.s/cm2",0,"fP",0,"kP",0,"kgf.s/m2",0,"lbf.s/ft2",0,"lbf.s/in2",0,"mP",0,"mPa.s",0,"nP",0,"pP",0,"psi.s",0,"uP",0),toFactor,SWITCH(to_unit,"Pa.s",1,"EP",100000000000000000,"GP",100000000,"MP",100000,"N.s/m2",1,"P",0.1,"TP",100000000000,"cP",0.001,"dP",0.01,"dyne.s/cm2",0.1,"fP",1E-16,"kP",100,"kgf.s/m2",9.80665,"lbf.s/ft2",47.88025898033584,"lbf.s/in2",6894.757293168361,"mP",0.0001,"mPa.s",0.001,"nP",1E-10,"pP",1E-13,"psi.s",6894.757293168361,"uP",1E-7),toShift,SWITCH(to_unit,"Pa.s",0,"EP",0,"GP",0,"MP",0,"N.s/m2",0,"P",0,"TP",0,"cP",0,"dP",0,"dyne.s/cm2",0,"fP",0,"kP",0,"kgf.s/m2",0,"lbf.s/ft2",0,"lbf.s/in2",0,"mP",0,"mPa.s",0,"nP",0,"pP",0,"psi.s",0,"uP",0),(value*fromFactor+fromShift-toShift)/toFactor))
ConvertElectricCurrent
Electric Current, 13 units. Open the converter
=ConvertElectricCurrent(1, "uA", "mA")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"A",1,"EA",1000000000000000000,"GA",1000000000,"MA",1000000,"TA",1000000000000,"cA",0.01,"dA",0.1,"fA",1E-15,"kA",1000,"mA",0.001,"nA",1E-9,"pA",1E-12,"uA",0.000001),fromShift,SWITCH(from_unit,"A",0,"EA",0,"GA",0,"MA",0,"TA",0,"cA",0,"dA",0,"fA",0,"kA",0,"mA",0,"nA",0,"pA",0,"uA",0),toFactor,SWITCH(to_unit,"A",1,"EA",1000000000000000000,"GA",1000000000,"MA",1000000,"TA",1000000000000,"cA",0.01,"dA",0.1,"fA",1E-15,"kA",1000,"mA",0.001,"nA",1E-9,"pA",1E-12,"uA",0.000001),toShift,SWITCH(to_unit,"A",0,"EA",0,"GA",0,"MA",0,"TA",0,"cA",0,"dA",0,"fA",0,"kA",0,"mA",0,"nA",0,"pA",0,"uA",0),(value*fromFactor+fromShift-toShift)/toFactor))
ConvertMomentOfForce
Moment Of Force, 12 units. Open the converter
=ConvertMomentOfForce(1, "N.m", "lbf.ft")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"N.m",1,"1000 lbf.ft",1355.8179483314004,"dN.m",0.1,"daN.m",10,"kN.m",1000,"kgf.m",9.80665,"lbf.ft",1.3558179483314003,"lbf.in",0.1129848290276167,"lbm.ft2/s2",0.0421401100938048,"pdl.ft",0.0421401100938048,"tonf[US].ft",2711.635896662801,"tonf[US].mi",14317437.534379588),fromShift,SWITCH(from_unit,"N.m",0,"1000 lbf.ft",0,"dN.m",0,"daN.m",0,"kN.m",0,"kgf.m",0,"lbf.ft",0,"lbf.in",0,"lbm.ft2/s2",0,"pdl.ft",0,"tonf[US].ft",0,"tonf[US].mi",0),toFactor,SWITCH(to_unit,"N.m",1,"1000 lbf.ft",1355.8179483314004,"dN.m",0.1,"daN.m",10,"kN.m",1000,"kgf.m",9.80665,"lbf.ft",1.3558179483314003,"lbf.in",0.1129848290276167,"lbm.ft2/s2",0.0421401100938048,"pdl.ft",0.0421401100938048,"tonf[US].ft",2711.635896662801,"tonf[US].mi",14317437.534379588),toShift,SWITCH(to_unit,"N.m",0,"1000 lbf.ft",0,"dN.m",0,"daN.m",0,"kN.m",0,"kgf.m",0,"lbf.ft",0,"lbf.in",0,"lbm.ft2/s2",0,"pdl.ft",0,"tonf[US].ft",0,"tonf[US].mi",0),(value*fromFactor+fromShift-toShift)/toFactor))
ConvertThermodynamicTemperature
Thermodynamic Temperature, 5 units. Open the converter
=ConvertThermodynamicTemperature(1, "degC", "degF")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"K",1,"degK",1,"degC",1,"degF",0.5555555555555556,"degR",0.5555555555555556),fromShift,SWITCH(from_unit,"K",0,"degK",0,"degC",273.15,"degF",255.3722222222222,"degR",0),toFactor,SWITCH(to_unit,"K",1,"degK",1,"degC",1,"degF",0.5555555555555556,"degR",0.5555555555555556),toShift,SWITCH(to_unit,"K",0,"degK",0,"degC",273.15,"degF",255.3722222222222,"degR",0),(value*fromFactor+fromShift-toShift)/toFactor))
ConvertLength
Length, 84 units. Open the converter
=ConvertLength(1, "m", "ft")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"m",1,"0.1 ft",0.03048,"0.1 ft[US]",0.03048006096012192,"0.1 in",0.00254,"0.1 yd",0.09144,"1/16 in",0.0015875,"1/2 ft",0.1524,"1/32 in",0.00079375,"1/64 in",0.000396875,"10 ft",3.048,"10 in",0.254,"10 km",10000,"100 ft",30.48,"100 km",100000,"1000 ft",304.8,"30 ft",9.144,"30 m",30,"Em",1000000000000000000,"Gm",1000000000,"Mm",1000000,"Tm",1000000000000,"angstrom",1E-10,"chain",20.1168,"chain[BnA]",20.1167824,"chain[BnB]",20.116782494375872,"chain[Cla]",20.1166195164,"chain[Ind37]",20.11669506,"chain[SeT]",20.116756,"chain[Se]",20.116765121552632,"chain[US]",20.11684023368047,"cm",0.01,"dam",10,"dm",0.1,"fathom",1.8288,"fm",1E-15,"ft",0.3048,"ft[BnA]",0.3047997333333333,"ft[BnB]",0.30479973476327077,"ft[Br36]",0.3048007491,"ft[Br65]",0.30480083333333335,"ft[Cla]",0.3047972654,"ft[GC]",0.3047997101815088,"ft[Ind37]",0.30479841,"ft[Ind62]",0.3047996,"ft[Ind75]",0.3047995,"ft[Ind]",0.30479951024814694,"ft[SeT]",0.30479933333333337,"ft[Se]",0.3047994715386762,"ft[US]",0.3048006096012192,"fur[US]",201.16840233680466,"hm",100,"in",0.0254,"in[US]",0.0254000508001016,"km",1000,"link",0.201168,"link[BnA]",0.201167824,"link[BnB]",0.2011678249437587,"link[Cla]",0.201166195164,"link[SeT]",0.20116756,"link[Se]",0.2011676512155263,"link[US]",0.2011684023368047,"m[Ger]",1.0000135965,"mi",1609.344,"mi[US]",1609.3472186944373,"mi[nautUK]",1853,"mi[naut]",1852,"mil",0.0000254,"mm",0.001,"nm",1E-9,"pm",1E-12,"rod[US]",5.029210058420117,"um",0.000001,"yd",0.9144,"yd[BnA]",0.9143992,"yd[BnB]",0.9143992042898124,"yd[Cla]",0.9143917962,"yd[Ind37]",0.91439523,"yd[Ind62]",0.9143988,"yd[Ind75]",0.9143985,"yd[Ind]",0.9143985307444408,"yd[SeT]",0.914398,"yd[Se]",0.9143984146160287,"yd[US]",0.9144018288036576,"nmi",1852),fromShift,SWITCH(from_unit,"m",0,"0.1 ft",0,"0.1 ft[US]",0,"0.1 in",0,"0.1 yd",0,"1/16 in",0,"1/2 ft",0,"1/32 in",0,"1/64 in",0,"10 ft",0,"10 in",0,"10 km",0,"100 ft",0,"100 km",0,"1000 ft",0,"30 ft",0,"30 m",0,"Em",0,"Gm",0,"Mm",0,"Tm",0,"angstrom",0,"chain",0,"chain[BnA]",0,"chain[BnB]",0,"chain[Cla]",0,"chain[Ind37]",0,"chain[SeT]",0,"chain[Se]",0,"chain[US]",0,"cm",0,"dam",0,"dm",0,"fathom",0,"fm",0,"ft",0,"ft[BnA]",0,"ft[BnB]",0,"ft[Br36]",0,"ft[Br65]",0,"ft[Cla]",0,"ft[GC]",0,"ft[Ind37]",0,"ft[Ind62]",0,"ft[Ind75]",0,"ft[Ind]",0,"ft[SeT]",0,"ft[Se]",0,"ft[US]",0,"fur[US]",0,"hm",0,"in",0,"in[US]",0,"km",0,"link",0,"link[BnA]",0,"link[BnB]",0,"link[Cla]",0,"link[SeT]",0,"link[Se]",0,"link[US]",0,"m[Ger]",0,"mi",0,"mi[US]",0,"mi[nautUK]",0,"mi[naut]",0,"mil",0,"mm",0,"nm",0,"pm",0,"rod[US]",0,"um",0,"yd",0,"yd[BnA]",0,"yd[BnB]",0,"yd[Cla]",0,"yd[Ind37]",0,"yd[Ind62]",0,"yd[Ind75]",0,"yd[Ind]",0,"yd[SeT]",0,"yd[Se]",0,"yd[US]",0,"nmi",0),toFactor,SWITCH(to_unit,"m",1,"0.1 ft",0.03048,"0.1 ft[US]",0.03048006096012192,"0.1 in",0.00254,"0.1 yd",0.09144,"1/16 in",0.0015875,"1/2 ft",0.1524,"1/32 in",0.00079375,"1/64 in",0.000396875,"10 ft",3.048,"10 in",0.254,"10 km",10000,"100 ft",30.48,"100 km",100000,"1000 ft",304.8,"30 ft",9.144,"30 m",30,"Em",1000000000000000000,"Gm",1000000000,"Mm",1000000,"Tm",1000000000000,"angstrom",1E-10,"chain",20.1168,"chain[BnA]",20.1167824,"chain[BnB]",20.116782494375872,"chain[Cla]",20.1166195164,"chain[Ind37]",20.11669506,"chain[SeT]",20.116756,"chain[Se]",20.116765121552632,"chain[US]",20.11684023368047,"cm",0.01,"dam",10,"dm",0.1,"fathom",1.8288,"fm",1E-15,"ft",0.3048,"ft[BnA]",0.3047997333333333,"ft[BnB]",0.30479973476327077,"ft[Br36]",0.3048007491,"ft[Br65]",0.30480083333333335,"ft[Cla]",0.3047972654,"ft[GC]",0.3047997101815088,"ft[Ind37]",0.30479841,"ft[Ind62]",0.3047996,"ft[Ind75]",0.3047995,"ft[Ind]",0.30479951024814694,"ft[SeT]",0.30479933333333337,"ft[Se]",0.3047994715386762,"ft[US]",0.3048006096012192,"fur[US]",201.16840233680466,"hm",100,"in",0.0254,"in[US]",0.0254000508001016,"km",1000,"link",0.201168,"link[BnA]",0.201167824,"link[BnB]",0.2011678249437587,"link[Cla]",0.201166195164,"link[SeT]",0.20116756,"link[Se]",0.2011676512155263,"link[US]",0.2011684023368047,"m[Ger]",1.0000135965,"mi",1609.344,"mi[US]",1609.3472186944373,"mi[nautUK]",1853,"mi[naut]",1852,"mil",0.0000254,"mm",0.001,"nm",1E-9,"pm",1E-12,"rod[US]",5.029210058420117,"um",0.000001,"yd",0.9144,"yd[BnA]",0.9143992,"yd[BnB]",0.9143992042898124,"yd[Cla]",0.9143917962,"yd[Ind37]",0.91439523,"yd[Ind62]",0.9143988,"yd[Ind75]",0.9143985,"yd[Ind]",0.9143985307444408,"yd[SeT]",0.914398,"yd[Se]",0.9143984146160287,"yd[US]",0.9144018288036576,"nmi",1852),toShift,SWITCH(to_unit,"m",0,"0.1 ft",0,"0.1 ft[US]",0,"0.1 in",0,"0.1 yd",0,"1/16 in",0,"1/2 ft",0,"1/32 in",0,"1/64 in",0,"10 ft",0,"10 in",0,"10 km",0,"100 ft",0,"100 km",0,"1000 ft",0,"30 ft",0,"30 m",0,"Em",0,"Gm",0,"Mm",0,"Tm",0,"angstrom",0,"chain",0,"chain[BnA]",0,"chain[BnB]",0,"chain[Cla]",0,"chain[Ind37]",0,"chain[SeT]",0,"chain[Se]",0,"chain[US]",0,"cm",0,"dam",0,"dm",0,"fathom",0,"fm",0,"ft",0,"ft[BnA]",0,"ft[BnB]",0,"ft[Br36]",0,"ft[Br65]",0,"ft[Cla]",0,"ft[GC]",0,"ft[Ind37]",0,"ft[Ind62]",0,"ft[Ind75]",0,"ft[Ind]",0,"ft[SeT]",0,"ft[Se]",0,"ft[US]",0,"fur[US]",0,"hm",0,"in",0,"in[US]",0,"km",0,"link",0,"link[BnA]",0,"link[BnB]",0,"link[Cla]",0,"link[SeT]",0,"link[Se]",0,"link[US]",0,"m[Ger]",0,"mi",0,"mi[US]",0,"mi[nautUK]",0,"mi[naut]",0,"mil",0,"mm",0,"nm",0,"pm",0,"rod[US]",0,"um",0,"yd",0,"yd[BnA]",0,"yd[BnB]",0,"yd[Cla]",0,"yd[Ind37]",0,"yd[Ind62]",0,"yd[Ind75]",0,"yd[Ind]",0,"yd[SeT]",0,"yd[Se]",0,"yd[US]",0,"nmi",0),(value*fromFactor+fromShift-toShift)/toFactor))
ConvertForce
Force, 27 units. Open the converter
=ConvertForce(1, "N", "lbf")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"N",1,"10 kN",10000,"EN",1000000000000000000,"GN",1000000000,"MN",1000000,"Mgf",9806.65,"TN",1000000000000,"cN",0.01,"dN",0.1,"daN",10,"dyne",0.00001,"fN",1E-15,"gf",0.00980665,"hN",100,"kN",1000,"kdyne",0.01,"kgf",9.80665,"klbf",4448.2216152605,"lbf",4.4482216152605,"mN",0.001,"nN",1E-9,"ozf",0.2780138509537812,"pN",1E-12,"pdl",0.138254954376,"tonf[UK]",9964.01641818352,"tonf[US]",8896.443230521,"uN",0.000001),fromShift,SWITCH(from_unit,"N",0,"10 kN",0,"EN",0,"GN",0,"MN",0,"Mgf",0,"TN",0,"cN",0,"dN",0,"daN",0,"dyne",0,"fN",0,"gf",0,"hN",0,"kN",0,"kdyne",0,"kgf",0,"klbf",0,"lbf",0,"mN",0,"nN",0,"ozf",0,"pN",0,"pdl",0,"tonf[UK]",0,"tonf[US]",0,"uN",0),toFactor,SWITCH(to_unit,"N",1,"10 kN",10000,"EN",1000000000000000000,"GN",1000000000,"MN",1000000,"Mgf",9806.65,"TN",1000000000000,"cN",0.01,"dN",0.1,"daN",10,"dyne",0.00001,"fN",1E-15,"gf",0.00980665,"hN",100,"kN",1000,"kdyne",0.01,"kgf",9.80665,"klbf",4448.2216152605,"lbf",4.4482216152605,"mN",0.001,"nN",1E-9,"ozf",0.2780138509537812,"pN",1E-12,"pdl",0.138254954376,"tonf[UK]",9964.01641818352,"tonf[US]",8896.443230521,"uN",0.000001),toShift,SWITCH(to_unit,"N",0,"10 kN",0,"EN",0,"GN",0,"MN",0,"Mgf",0,"TN",0,"cN",0,"dN",0,"daN",0,"dyne",0,"fN",0,"gf",0,"hN",0,"kN",0,"kdyne",0,"kgf",0,"klbf",0,"lbf",0,"mN",0,"nN",0,"ozf",0,"pN",0,"pdl",0,"tonf[UK]",0,"tonf[US]",0,"uN",0),(value*fromFactor+fromShift-toShift)/toFactor))
ConvertEnergy
Energy, 56 units. Open the converter
=ConvertEnergy(1, "kJ", "Btu[IT]")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"J",1,"1E6 Btu[IT]",1055055852.62,"Btu[IT]",1055.05585262,"Btu[UK]",1055.05585257348,"Btu[th]",1054.350264488889,"EJ",1000000000000000000,"Ecal[th]",4184000000000000000,"EeV",0.1602176487,"GJ",1000000000,"GW.h",3600000000000,"Gcal[th]",4184000000,"GeV",1.602176487E-10,"MJ",1000000,"MW.h",3600000000,"Mcal[th]",4184000,"MeV",1.602176487E-13,"TJ",1000000000000,"TW.h",3600000000000000,"Tcal[th]",4184000000000,"TeV",1.602176487E-7,"aJ",1E-18,"cJ",0.01,"cal[IT]",4.1868,"cal[th]",4.184,"ccal[th]",0.04184,"ceV",1.602176487E-21,"dJ",0.1,"dcal[th]",0.4184,"deV",1.602176487E-20,"eV",1.602176487E-19,"erg",1E-7,"fJ",1E-15,"fcal[th]",4.184E-15,"feV",1.602176487E-34,"hp.h",2684519.537696173,"hp[metric].h",2647795.5,"kJ",1000,"kW.h",3600000,"kcal[th]",4184,"keV",1.602176487E-16,"mJ",0.001,"mcal[th]",0.004184,"meV",1.602176487E-22,"nJ",1E-9,"ncal[th]",4.184E-9,"neV",1.602176487E-28,"pJ",1E-12,"pcal[th]",4.184E-12,"peV",1.602176487E-31,"quad",1055055852620000000,"therm[EC]",105506000,"therm[UK]",105505585.257348,"therm[US]",105480400,"uJ",0.000001,"ucal[th]",0.000004184,"ueV",1.602176487E-25),fromShift,SWITCH(from_unit,"J",0,"1E6 Btu[IT]",0,"Btu[IT]",0,"Btu[UK]",0,"Btu[th]",0,"EJ",0,"Ecal[th]",0,"EeV",0,"GJ",0,"GW.h",0,"Gcal[th]",0,"GeV",0,"MJ",0,"MW.h",0,"Mcal[th]",0,"MeV",0,"TJ",0,"TW.h",0,"Tcal[th]",0,"TeV",0,"aJ",0,"cJ",0,"cal[IT]",0,"cal[th]",0,"ccal[th]",0,"ceV",0,"dJ",0,"dcal[th]",0,"deV",0,"eV",0,"erg",0,"fJ",0,"fcal[th]",0,"feV",0,"hp.h",0,"hp[metric].h",0,"kJ",0,"kW.h",0,"kcal[th]",0,"keV",0,"mJ",0,"mcal[th]",0,"meV",0,"nJ",0,"ncal[th]",0,"neV",0,"pJ",0,"pcal[th]",0,"peV",0,"quad",0,"therm[EC]",0,"therm[UK]",0,"therm[US]",0,"uJ",0,"ucal[th]",0,"ueV",0),toFactor,SWITCH(to_unit,"J",1,"1E6 Btu[IT]",1055055852.62,"Btu[IT]",1055.05585262,"Btu[UK]",1055.05585257348,"Btu[th]",1054.350264488889,"EJ",1000000000000000000,"Ecal[th]",4184000000000000000,"EeV",0.1602176487,"GJ",1000000000,"GW.h",3600000000000,"Gcal[th]",4184000000,"GeV",1.602176487E-10,"MJ",1000000,"MW.h",3600000000,"Mcal[th]",4184000,"MeV",1.602176487E-13,"TJ",1000000000000,"TW.h",3600000000000000,"Tcal[th]",4184000000000,"TeV",1.602176487E-7,"aJ",1E-18,"cJ",0.01,"cal[IT]",4.1868,"cal[th]",4.184,"ccal[th]",0.04184,"ceV",1.602176487E-21,"dJ",0.1,"dcal[th]",0.4184,"deV",1.602176487E-20,"eV",1.602176487E-19,"erg",1E-7,"fJ",1E-15,"fcal[th]",4.184E-15,"feV",1.602176487E-34,"hp.h",2684519.537696173,"hp[metric].h",2647795.5,"kJ",1000,"kW.h",3600000,"kcal[th]",4184,"keV",1.602176487E-16,"mJ",0.001,"mcal[th]",0.004184,"meV",1.602176487E-22,"nJ",1E-9,"ncal[th]",4.184E-9,"neV",1.602176487E-28,"pJ",1E-12,"pcal[th]",4.184E-12,"peV",1.602176487E-31,"quad",1055055852620000000,"therm[EC]",105506000,"therm[UK]",105505585.257348,"therm[US]",105480400,"uJ",0.000001,"ucal[th]",0.000004184,"ueV",1.602176487E-25),toShift,SWITCH(to_unit,"J",0,"1E6 Btu[IT]",0,"Btu[IT]",0,"Btu[UK]",0,"Btu[th]",0,"EJ",0,"Ecal[th]",0,"EeV",0,"GJ",0,"GW.h",0,"Gcal[th]",0,"GeV",0,"MJ",0,"MW.h",0,"Mcal[th]",0,"MeV",0,"TJ",0,"TW.h",0,"Tcal[th]",0,"TeV",0,"aJ",0,"cJ",0,"cal[IT]",0,"cal[th]",0,"ccal[th]",0,"ceV",0,"dJ",0,"dcal[th]",0,"deV",0,"eV",0,"erg",0,"fJ",0,"fcal[th]",0,"feV",0,"hp.h",0,"hp[metric].h",0,"kJ",0,"kW.h",0,"kcal[th]",0,"keV",0,"mJ",0,"mcal[th]",0,"meV",0,"nJ",0,"ncal[th]",0,"neV",0,"pJ",0,"pcal[th]",0,"peV",0,"quad",0,"therm[EC]",0,"therm[UK]",0,"therm[US]",0,"uJ",0,"ucal[th]",0,"ueV",0),(value*fromFactor+fromShift-toShift)/toFactor))
ConvertVolume
Volume, 68 units. Open the converter
=ConvertVolume(1, "bbl", "m3")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"m3",1,"1000 bbl",158.987294928,"1000 ft3",28.316846592,"1000 gal[UK]",4.54609,"1000 gal[US]",3.785411784,"1000 m3",1000,"E3m3",1000,"1E-6 gal[US]",3.785411784E-9,"1E12 ft3",28316846592,"1E6 bbl",158987.294928,"1E6 ft3",28316.846592,"1E6 m3",1000000,"E6m3",1000000,"1E9 bbl",158987294.928,"1E9 ft3",28316846.592,"L",0.001,"acre.ft",1233.486771489672,"bbl",0.158987294928,"cm3",0.000001,"dm3",0.001,"floz[UK]",0.0000284130625,"floz[US]",0.0000295735295625,"ft3",0.028316846592,"gal[UK]",0.00454609,"gal[US]",0.003785411784,"hL",0.1,"ha.m",10000,"in3",0.000016387064,"km3",1000000000,"mL",0.000001,"mi3",4168181825.4405794,"mm3",1E-9,"pt[UK]",0.00056826125,"pt[US]",0.000473176473,"qt[UK]",0.0011365225,"qt[US]",0.000946352946,"um2.m",1E-12,"yd3",0.764554857984,"SM3",1,"l",0.001,"ml",0.000001,"gal",0.003785411784,"mbbl",158.987294928,"mmbbl",158987.29492800002,"scf",0.028316846592,"mscf",28.316846592,"mmscf",28316.846592,"bcf",28316846.592,"STB",0.158987294928,"stb",0.158987294928,"BBL",0.158987294928,"MSTB",158.987294928,"mstb",158.987294928,"MMSTB",158987.29492800002,"mmstb",158987.29492800002,"SCF",0.028316846592,"MSCF",28.316846592,"MMSCF",28316.846592,"BCF",28316846.592,"cup[US]",0.0002365882365,"cup[UK]",0.000284130625,"cup[metric]",0.00025,"tbsp[US]",0.00001478676478125,"tbsp[UK]",0.00001420653125,"tbsp[metric]",0.000015,"tsp[US]",0.00000492892159375,"tsp[UK]",0.0000035516328125,"tsp[metric]",0.000005),fromShift,SWITCH(from_unit,"m3",0,"1000 bbl",0,"1000 ft3",0,"1000 gal[UK]",0,"1000 gal[US]",0,"1000 m3",0,"E3m3",0,"1E-6 gal[US]",0,"1E12 ft3",0,"1E6 bbl",0,"1E6 ft3",0,"1E6 m3",0,"E6m3",0,"1E9 bbl",0,"1E9 ft3",0,"L",0,"acre.ft",0,"bbl",0,"cm3",0,"dm3",0,"floz[UK]",0,"floz[US]",0,"ft3",0,"gal[UK]",0,"gal[US]",0,"hL",0,"ha.m",0,"in3",0,"km3",0,"mL",0,"mi3",0,"mm3",0,"pt[UK]",0,"pt[US]",0,"qt[UK]",0,"qt[US]",0,"um2.m",0,"yd3",0,"SM3",0,"l",0,"ml",0,"gal",0,"mbbl",0,"mmbbl",0,"scf",0,"mscf",0,"mmscf",0,"bcf",0,"STB",0,"stb",0,"BBL",0,"MSTB",0,"mstb",0,"MMSTB",0,"mmstb",0,"SCF",0,"MSCF",0,"MMSCF",0,"BCF",0,"cup[US]",0,"cup[UK]",0,"cup[metric]",0,"tbsp[US]",0,"tbsp[UK]",0,"tbsp[metric]",0,"tsp[US]",0,"tsp[UK]",0,"tsp[metric]",0),toFactor,SWITCH(to_unit,"m3",1,"1000 bbl",158.987294928,"1000 ft3",28.316846592,"1000 gal[UK]",4.54609,"1000 gal[US]",3.785411784,"1000 m3",1000,"E3m3",1000,"1E-6 gal[US]",3.785411784E-9,"1E12 ft3",28316846592,"1E6 bbl",158987.294928,"1E6 ft3",28316.846592,"1E6 m3",1000000,"E6m3",1000000,"1E9 bbl",158987294.928,"1E9 ft3",28316846.592,"L",0.001,"acre.ft",1233.486771489672,"bbl",0.158987294928,"cm3",0.000001,"dm3",0.001,"floz[UK]",0.0000284130625,"floz[US]",0.0000295735295625,"ft3",0.028316846592,"gal[UK]",0.00454609,"gal[US]",0.003785411784,"hL",0.1,"ha.m",10000,"in3",0.000016387064,"km3",1000000000,"mL",0.000001,"mi3",4168181825.4405794,"mm3",1E-9,"pt[UK]",0.00056826125,"pt[US]",0.000473176473,"qt[UK]",0.0011365225,"qt[US]",0.000946352946,"um2.m",1E-12,"yd3",0.764554857984,"SM3",1,"l",0.001,"ml",0.000001,"gal",0.003785411784,"mbbl",158.987294928,"mmbbl",158987.29492800002,"scf",0.028316846592,"mscf",28.316846592,"mmscf",28316.846592,"bcf",28316846.592,"STB",0.158987294928,"stb",0.158987294928,"BBL",0.158987294928,"MSTB",158.987294928,"mstb",158.987294928,"MMSTB",158987.29492800002,"mmstb",158987.29492800002,"SCF",0.028316846592,"MSCF",28.316846592,"MMSCF",28316.846592,"BCF",28316846.592,"cup[US]",0.0002365882365,"cup[UK]",0.000284130625,"cup[metric]",0.00025,"tbsp[US]",0.00001478676478125,"tbsp[UK]",0.00001420653125,"tbsp[metric]",0.000015,"tsp[US]",0.00000492892159375,"tsp[UK]",0.0000035516328125,"tsp[metric]",0.000005),toShift,SWITCH(to_unit,"m3",0,"1000 bbl",0,"1000 ft3",0,"1000 gal[UK]",0,"1000 gal[US]",0,"1000 m3",0,"E3m3",0,"1E-6 gal[US]",0,"1E12 ft3",0,"1E6 bbl",0,"1E6 ft3",0,"1E6 m3",0,"E6m3",0,"1E9 bbl",0,"1E9 ft3",0,"L",0,"acre.ft",0,"bbl",0,"cm3",0,"dm3",0,"floz[UK]",0,"floz[US]",0,"ft3",0,"gal[UK]",0,"gal[US]",0,"hL",0,"ha.m",0,"in3",0,"km3",0,"mL",0,"mi3",0,"mm3",0,"pt[UK]",0,"pt[US]",0,"qt[UK]",0,"qt[US]",0,"um2.m",0,"yd3",0,"SM3",0,"l",0,"ml",0,"gal",0,"mbbl",0,"mmbbl",0,"scf",0,"mscf",0,"mmscf",0,"bcf",0,"STB",0,"stb",0,"BBL",0,"MSTB",0,"mstb",0,"MMSTB",0,"mmstb",0,"SCF",0,"MSCF",0,"MMSCF",0,"BCF",0,"cup[US]",0,"cup[UK]",0,"cup[metric]",0,"tbsp[US]",0,"tbsp[UK]",0,"tbsp[metric]",0,"tsp[US]",0,"tsp[UK]",0,"tsp[metric]",0),(value*fromFactor+fromShift-toShift)/toFactor))
ConvertSecondMomentOfArea
Second Moment Of Area, 3 units. Open the converter
=ConvertSecondMomentOfArea(1, "cm4", "m4")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"m4",1,"cm4",1E-8,"in4",4.162314256E-7),fromShift,SWITCH(from_unit,"m4",0,"cm4",0,"in4",0),toFactor,SWITCH(to_unit,"m4",1,"cm4",1E-8,"in4",4.162314256E-7),toShift,SWITCH(to_unit,"m4",0,"cm4",0,"in4",0),(value*fromFactor+fromShift-toShift)/toFactor))
ConvertElectricResistance
Electric Resistance, 13 units. Open the converter
=ConvertElectricResistance(1, "mohm", "ohm")
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"ohm",1,"Eohm",1000000000000000000,"Gohm",1000000000,"Mohm",1000000,"Tohm",1000000000000,"cohm",0.01,"dohm",0.1,"fohm",1E-15,"kohm",1000,"mohm",0.001,"nohm",1E-9,"pohm",1E-12,"uohm",0.000001),fromShift,SWITCH(from_unit,"ohm",0,"Eohm",0,"Gohm",0,"Mohm",0,"Tohm",0,"cohm",0,"dohm",0,"fohm",0,"kohm",0,"mohm",0,"nohm",0,"pohm",0,"uohm",0),toFactor,SWITCH(to_unit,"ohm",1,"Eohm",1000000000000000000,"Gohm",1000000000,"Mohm",1000000,"Tohm",1000000000000,"cohm",0.01,"dohm",0.1,"fohm",1E-15,"kohm",1000,"mohm",0.001,"nohm",1E-9,"pohm",1E-12,"uohm",0.000001),toShift,SWITCH(to_unit,"ohm",0,"Eohm",0,"Gohm",0,"Mohm",0,"Tohm",0,"cohm",0,"dohm",0,"fohm",0,"kohm",0,"mohm",0,"nohm",0,"pohm",0,"uohm",0),(value*fromFactor+fromShift-toShift)/toFactor))
Microsoft 365. Paste the function into Name Manager without a call at the end. The line above each function is an example call.
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.