# Formula to convert metric to imperial

1. ## Formula to convert metric to imperial

I'm trying to formulate some basic metric conversions in Excel. Just starting off, and I'm already stuck.

To convert kilograms to pounds, you multiply kilograms by 2.20, which equals 4.40, but actually it should be 4 pounds and 6.55 ounces. How can I create a formula that will give such results? There's 16 ounces in a pound, so I need to figure out how to equate anything to the right of the decimal to ounces.

Any suggestions?

2. ## Re: Formula to convert metric to imperial

Wrong Solution.

Convert Everything to Ounces.

Then Devide by 16 to get pounds

https://www.tlc-direct.co.uk/Technic...lculators.html

1kg = 35.3 ounces

=INT(A1/35.3/16)& " pounds and "& ROUND(A1/35.3-INT(A1/35.3/16)*16,2) &" ounces"

3. ## Re: Formula to convert metric to imperial

Here's how I might do it:

In the cell where you do the conversion to decimal pounds =CONVERT(cell with kg,"kg","lbm")
In the cell where you want the integer pounds =INT(cell with convert formula)
In the cell where you want the ounces =CONVERT(cell with convert formula - cell with INT() formula,"lbm","ozm")

The answers might be a little different, because the CONVERT() function will use more accurate conversion factors than "2.2 lbs/kg" (My version appears to use 2.204623... lbs/kg). If you are uncomfortable with the CONVERT() function (https://support.office.com/en-us/art...d-666c810f9af2 ), you can replace those with suitable multiplication functions by the desired conversion factors.

4. ## Re: Formula to convert metric to imperial

Another way, assuming 2 is in A2....
In B2:
Formula:
`Please Login or Register  to view this content.`

5. ## Re: Formula to convert metric to imperial

you would need to get the INT() and then you can concatenate the ounces
if the KG was in F7 and the conversion of 1 KG to Pounds in E7

the conversion is 2.20462

=INT(F7)&" pounds "&(((E7*F7)-INT(E7*F7)))*16&" Ounces"

otherwise you will be a little out on ounces

6. ## Re: Formula to convert metric to imperial

Goodness, you guys are fast. Thanks for all the replies and suggestions!

I'm playing with them now and will report back.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1