# 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?  Register To Reply

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"  Register To Reply

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.  Register To Reply

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.`  Register To Reply

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  Register To Reply

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.  Register To Reply