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?
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"
Last edited by mehmetcik; 12-12-2018 at 03:48 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
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.
Originally Posted by shg
Another way, assuming 2 is in A2....
In B2:
Formula:
Please Login or Register to view this content.
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
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks