Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Request Math Formula

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

    Default

    Need formula to convert meters to feet and inches instead of meters to feet and tenths.
    Thanks
    Jay

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here's one way that requires the Analysis ToolPak add-in.

    =TRUNC(CONVERT(A1,"m","ft"))&"' "&ROUND(CONVERT(MOD(CONVERT(A1,"m","ft"),1),"ft","in"),0) &""""

    CONVERT is handy if you don't know the conversion factors or if you want to specify your units of measure in a worksheet cell and modify them as needed.

    [ This Message was edited by: Mark W. on 2002-03-07 10:39 ]

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

    Default

    Here's a way to do it. I'm sure you can adapt this to your application.

    1 meters
    39.3701 conversion factor
    39.3701 total inches
    3.3701 inches
    3 feet

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

    Default

    Here's a way to do it. I'm sure you can adapt this to your application.

    A B
    1 1 meters
    2 39.3701 conversion factor
    3 39.3701 total inches =(A1*A2)
    4 3.3701 inches =(MOD(A3,12)
    5 3 feet =TRUNC(INT(A3)/12)


    [ This Message was edited by: Dave Gibson on 2002-03-07 10:00 ]

Some videos you may like

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
  •