What is the formula to convert Imperial measurements to Metric measurements
accurately in an Excel spreadsheet?
What is the formula to convert Imperial measurements to Metric measurements
accurately in an Excel spreadsheet?
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 <at>yahoo<dot>com
----
"compu_trainer" <compu_trainer@discussions.microsoft.com> wrote in message
news:7CED215C-EF03-4B85-91BF-95DE97E277ED@microsoft.com...
> What is the formula to convert Imperial measurements to Metric
measurements
> accurately in an Excel spreadsheet?
Hi
There are 2.54cm to 1 inch, so you multiply inches by 2.54 to get cm.
--
Andy.
"Max" <demechanik@yahoo.com> wrote in message
news:uApnDrbYFHA.1404@TK2MSFTNGP09.phx.gbl...
> 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 <at>yahoo<dot>com
> ----
> "compu_trainer" <compu_trainer@discussions.microsoft.com> wrote in message
> news:7CED215C-EF03-4B85-91BF-95DE97E277ED@microsoft.com...
>> What is the formula to convert Imperial measurements to Metric
> measurements
>> accurately in an Excel spreadsheet?
>
>
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" <compu_trainer@discussions.microsoft.com> wrote in message
news:7CED215C-EF03-4B85-91BF-95DE97E277ED@microsoft.com...
> What is the formula to convert Imperial measurements to Metric
> measurements
> accurately in an Excel spreadsheet?
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" <demechanik@yahoo.com> wrote in message
> news:uApnDrbYFHA.1404@TK2MSFTNGP09.phx.gbl...
> > 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 <at>yahoo<dot>com
> > ----
> > "compu_trainer" <compu_trainer@discussions.microsoft.com> wrote in message
> > news:7CED215C-EF03-4B85-91BF-95DE97E277ED@microsoft.com...
> >> What is the formula to convert Imperial measurements to Metric
> > measurements
> >> accurately in an Excel spreadsheet?
> >
> >
>
>
>
"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 <at>yahoo<dot>com
----
"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 <at>yahoo<dot>com
----
"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 <at>yahoo<dot>com
----
"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 <at>yahoo<dot>com
----
"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 <at>yahoo<dot>com
----
"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 <at>yahoo<dot>com
----
"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 <at>yahoo<dot>com
----
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks