Kilograms
Kilograms
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Kilograms

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I don't know if this is a 2nd posting. I'm just learing this board. If it is, I'm sorry.

    I have 2 cells. D2 is where we enter the pounds of something. In D1 we want a formula to convert D2 into Kilograms. How can we do that?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    SRC
    Posts
    165
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =D2*2.2 would do it.
    On 2002-02-19 14:09, justine wrote:
    I don't know if this is a 2nd posting. I'm just learing this board. If it is, I'm sorry.

    I have 2 cells. D2 is where we enter the pounds of something. In D1 we want a formula to convert D2 into Kilograms. How can we do that?

  3. #3
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you have pounds in A1, then in B1, type:

    =A1*.4536

    Hope this helps,

    Russell

  4. #4
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry for not paying attention. In cell D1, type:

    =D2*.4536

  5. #5
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could also use the CONVERT function. The syntax would be:

    =CONVERT(D2,"lbm","g")/1000

    Quote from Excel's help

    "Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

    If this function is not available, run the
    Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using Add-Ins on the Tools menu."
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  6. #6
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-02-19 15:51, Barrie Davidson wrote:
    You could also use the CONVERT function. The syntax would be:

    =CONVERT(D2,"lbm","g")/1000

    Quote from Excel's help

    "Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

    If this function is not available, run the
    Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using Add-Ins on the Tools menu."
    Good one, Barry - I was looking for that but forgot what the function was called!

    -rh

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com