Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is the Formula to Convert Imperial to Metric Measurements
What is the formula to convert Imperial measurements to Metric measurements
accurately in an Excel spreadsheet? |
#2
|
|||
|
|||
Try checking up the CONVERT function in Excel's Help
(requires that the Analysis Toolpak be installed and enabled) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "compu_trainer" wrote in message ... What is the formula to convert Imperial measurements to Metric measurements accurately in an Excel spreadsheet? |
#3
|
|||
|
|||
Hi
There are 2.54cm to 1 inch, so you multiply inches by 2.54 to get cm. -- Andy. "Max" wrote in message ... Try checking up the CONVERT function in Excel's Help (requires that the Analysis Toolpak be installed and enabled) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "compu_trainer" wrote in message ... What is the formula to convert Imperial measurements to Metric measurements accurately in an Excel spreadsheet? |
#4
|
|||
|
|||
The only Imperial unit Excel's CONVERT knows about is the pint
=CONVERT(A1,"uk_pt","ml" gives 568.260698087162 (when A1 =1) To convert fluid ounces: =CONVERT(A1/20,"uk_pt","ml") remember there are 20 fluid ounces in an Imperial pint not 16 as in US pint and the ounces are of different size Google is a great place to get conversion values Enter "1 imperial pint to litres" (without quotes) in the search box and Google replies 1 Imperial pint = 0.568261485 litres best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "compu_trainer" wrote in message ... What is the formula to convert Imperial measurements to Metric measurements accurately in an Excel spreadsheet? |
#5
|
|||
|
|||
Hi Andy
Thanks for your reply, and if I work in whole numbers, this is accurate. But when I use numbers like 3 7/16, the conversion is not accurate unless I place the whole number in one cell, and the fraction in a separate cell, then * each cell by 25.4 and then add them together. Is this what you do? Compu_trainer "Andy B" wrote: Hi There are 2.54cm to 1 inch, so you multiply inches by 2.54 to get cm. -- Andy. "Max" wrote in message ... Try checking up the CONVERT function in Excel's Help (requires that the Analysis Toolpak be installed and enabled) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "compu_trainer" wrote in message ... What is the formula to convert Imperial measurements to Metric measurements accurately in an Excel spreadsheet? |
#6
|
|||
|
|||
"compu_trainer" wrote:
..... But when I use numbers like 3 7/16, the conversion is not accurate unless I place the whole number in one cell, and the fraction in a separate cell, then * each cell by 25.4 and then add them together... FWIW ... if you input in A1: 3, in B1: 7/16 with B1 formatted as Fraction (As sixteenths) you could put in C1: =CONVERT(SUM(A1:B1),"in","m")*100 which yields: 8.73125 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Frequency formula | Excel Worksheet Functions | |||
Metric to imperial measurements | Excel Discussion (Misc queries) | |||
convert formula to its value | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |