Length Unit Converter in Excel
1 British foot [1936] = 1.000004064 indian foot
Formula for this pair
These units are a straight multiple of each other. Put the starting value in cell A1.
=A1*1.000004064
Once you have saved the function below, type this in a cell
=ConvertLength(1, "ft[Br36]", "ft[Ind]")
CONVERT
Excel's CONVERT function has no code for British foot [1936] (ft[Br36]) or indian foot (ft[Ind]). Use the formula above. It uses this site's conversion factors.
How to save as a reusable Excel function
Microsoft 365. No VBA and no add-in.
- Open the function below and copy it. It has no call at the end.
- On the Formulas tab, choose Name Manager, then New.
- Set the name to ConvertLength. Leave the scope as Workbook.
- Paste the function into Refers to.
- In a cell, type the call shown above.
ConvertLength
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))
Conversion factors
The factors this converter uses. Copy them into Excel as tab-separated values.
| Symbol | Name | Factor | Excel code |
|---|---|---|---|
| m | metre | 1 | m |
| 0.1 ft | tenth of foot | 0.03048 | — |
| 0.1 ft[US] | tenth of US survey foot | 0.03048006096012192 | — |
| 0.1 in | tenth of inch | 0.00254 | — |
| 0.1 yd | tenth of yard | 0.09144 | — |
| 1/16 in | sixteenth of inch | 0.0015875 | — |
| 1/2 ft | half of Foot | 0.1524 | — |
| 1/32 in | thirty-second of inch | 0.00079375 | — |
| 1/64 in | sixty-fourth of inch | 0.000396875 | — |
| 10 ft | ten foot | 3.048 | — |
| 10 in | ten inch | 0.254 | — |
| 10 km | 10 kilometre | 10000 | — |
| 100 ft | hundred foot | 30.48 | — |
| 100 km | 100 kilometre | 100000 | — |
| 1000 ft | thousand foot | 304.8 | — |
| 30 ft | thirty foot | 9.144 | — |
| 30 m | thirty metres | 30 | — |
| Em | exametre | 1000000000000000000 | Em |
| Gm | gigametre | 1000000000 | Gm |
| Mm | megametre | 1000000 | Mm |
| Tm | terametre | 1000000000000 | Tm |
| angstrom | angstrom | 1E-10 | ang |
| chain | chain | 20.1168 | — |
| chain[BnA] | British chain [Benoit 1895 A] | 20.1167824 | — |
| chain[BnB] | British chain [Benoit 1895 B] | 20.116782494375872 | — |
| chain[Cla] | Clarke chain | 20.1166195164 | — |
| chain[Ind37] | Indian Chain [1937] | 20.11669506 | — |
| chain[SeT] | British chain [Sears 1922 truncated] | 20.116756 | — |
| chain[Se] | British chain [Sears 1922] | 20.116765121552632 | — |
| chain[US] | US survey chain | 20.11684023368047 | — |
| cm | centimetre | 0.01 | cm |
| dam | dekametre | 10 | dam |
| dm | decimetre | 0.1 | dm |
| fathom | international fathom | 1.8288 | — |
| fm | femtometre | 1E-15 | fm |
| ft | foot | 0.3048 | ft |
| ft[BnA] | British foot [Benoit 1895 A] | 0.3047997333333333 | — |
| ft[BnB] | British foot [Benoit 1895 B] | 0.30479973476327077 | — |
| ft[Br36] | British foot [1936] | 0.3048007491 | — |
| ft[Br65] | British foot [1865] | 0.30480083333333335 | — |
| ft[Cla] | Clarke foot | 0.3047972654 | — |
| ft[GC] | Gold Coast foot | 0.3047997101815088 | — |
| ft[Ind37] | indian foot [1937] | 0.30479841 | — |
| ft[Ind62] | indian foot ]1962] | 0.3047996 | — |
| ft[Ind75] | indian foot [1975] | 0.3047995 | — |
| ft[Ind] | indian foot | 0.30479951024814694 | — |
| ft[SeT] | British foot [Sears 1922 truncated] | 0.30479933333333337 | — |
| ft[Se] | British foot [Sears 1922] | 0.3047994715386762 | — |
| ft[US] | US survey foot | 0.3048006096012192 | — |
| fur[US] | furlong US survey | 201.16840233680466 | — |
| hm | hectometre | 100 | hm |
| in | inch | 0.0254 | in |
| in[US] | US survey inch | 0.0254000508001016 | — |
| km | kilometre | 1000 | km |
| link | link | 0.201168 | — |
| link[BnA] | British link [Benoit 1895 A] | 0.201167824 | — |
| link[BnB] | British link [Benoit 1895 B] | 0.2011678249437587 | — |
| link[Cla] | Clarke link | 0.201166195164 | — |
| link[SeT] | British link [Sears 1922 truncated] | 0.20116756 | — |
| link[Se] | British link [Sears 1922] | 0.2011676512155263 | — |
| link[US] | US survey link | 0.2011684023368047 | — |
| m[Ger] | German legal metre | 1.0000135965 | — |
| mi | mile | 1609.344 | mi |
| mi[US] | US survey mile | 1609.3472186944373 | survey_mi |
| mi[nautUK] | United Kingdom nautical mile | 1853 | — |
| mi[naut] | international nautical mile | 1852 | Nmi |
| mil | mil | 0.0000254 | — |
| mm | millimetre | 0.001 | mm |
| nm | nanometre | 1E-9 | nm |
| pm | picometre | 1E-12 | pm |
| rod[US] | rod US Survey | 5.029210058420117 | — |
| um | micrometre | 0.000001 | um |
| yd | yard | 0.9144 | yd |
| yd[BnA] | British yard [Benoit 1895 A] | 0.9143992 | — |
| yd[BnB] | British yard [Benoit 1895 B] | 0.9143992042898124 | — |
| yd[Cla] | Clarke yard | 0.9143917962 | — |
| yd[Ind37] | Indian yard [1937] | 0.91439523 | — |
| yd[Ind62] | Indian yard [1962] | 0.9143988 | — |
| yd[Ind75] | Indian yard [1975] | 0.9143985 | — |
| yd[Ind] | Indian yard | 0.9143985307444408 | — |
| yd[SeT] | British yard [Sears 1922 truncated] | 0.914398 | — |
| yd[Se] | British yard [Sears 1922] | 0.9143984146160287 | — |
| yd[US] | US survey yard | 0.9144018288036576 | — |
| nmi | international nautical mile | 1852 | Nmi |
Notes
The international foot, inch, yard and mile match ft, in, yd and mi. The US survey mile is survey_mi. The international nautical mile, nmi and mi[naut], is Nmi. The UK nautical mile is not. A count such as 10 km is not the code km. Angstrom is ang.
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.