+ Reply to Thread
Results 1 to 6 of 6

Formula to convert metric to imperial

  1. #1
    Forum Contributor
    Join Date
    05-16-2007
    Location
    USA
    MS-Off Ver
    MS Office 2016, Excel 2016
    Posts
    192

    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. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    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"
    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.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,448

    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.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Formula to convert metric to imperial

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

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,230

    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
    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.

  6. #6
    Forum Contributor
    Join Date
    05-16-2007
    Location
    USA
    MS-Off Ver
    MS Office 2016, Excel 2016
    Posts
    192

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Metric to Imperial
    By lockye in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2013, 12:43 PM
  2. Replies: 2
    Last Post: 06-20-2012, 03:37 PM
  3. Replies: 2
    Last Post: 06-20-2012, 03:01 PM
  4. Converting metric to imperial measurements
    By mdoyle13 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-16-2012, 03:58 AM
  5. Imperial / metric units
    By bejan in forum Excel General
    Replies: 2
    Last Post: 05-13-2009, 03:42 AM
  6. [SOLVED] What is the Formula to Convert Imperial to Metric Measurements
    By compu_trainer in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] Metric to imperial measurements
    By Gill.star in forum Excel General
    Replies: 7
    Last Post: 03-06-2005, 10:06 PM
  8. Replies: 1
    Last Post: 02-23-2005, 09:23 PM

Bookmarks

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