Results 1 to 12 of 12
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post
    Hi I trying to convert kilos to pounds and then to stones & pounds, but I get too many digits on the end of the pounds, I have tried to use the rounddown but I can't get it to work.

    any help would be appreciated

    Regards

    Braddy
    Attached Files Attached Files
    If you are a fool at forty, you will always be a fool

  2. #2
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='braddy60' post='791258' date='29-Aug-2009 13:36']Hi I trying to convert kilos to pounds and then to stones & pounds, but I get too many digits on the end of the pounds, I have tried to use the rounddown but I can't get it to work.

    any help would be appreciated

    Regards

    Braddy[/quote]
    Looking for something like this?
    Attached Files Attached Files
    Regards
    Prasad

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post
    [quote name='prasad' post='791262' date='29-Aug-2009 09:20']Looking for something like this?[/quote]


    Thanks for the prompt reply much appreciated.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    Since the measured value (67.9 kilos) has only 3 significant digits (sd), the results should be limited to 3 sd i.e. 149 pounds and 10 stones, 9 pounds. My challenge is to develop a technique to achieve this through formulae. Any ideas?
    Regards
    Don

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    One could also argue that the kg value is accurate to one decimal place. Since 0.1 kg ~ 0.2 lb, one could round to the nearest multiple of 0.2 lb using the MROUND function from the Analysis ToolPak.

  6. #6
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='HansV' post='791283' date='29-Aug-2009 10:32']One could also argue that the kg value is accurate to one decimal place. Since 0.1 kg ~ 0.2 lb, one could round to the nearest multiple of 0.2 lb using the MROUND function from the Analysis ToolPak.[/quote]
    I believe that the scientific world would take this view.
    Regards
    Don

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    But surely someone who wants to display a weight in stones and pounds is not interested in the view of the scientific world?

  8. #8
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='HansV' post='791287' date='29-Aug-2009 10:48']But surely someone who wants to display a weight in stones and pounds is not interested in the view of the scientific world? [/quote]

    Good gracious Hans; EVERYONE should be interested in the view of the scientific world. But the discussion in my post was a segue into the challenge of presenting the results of a calculation with the appropriate number of significant digits (in a scientists view), without the intervention of the user.
    Regards
    Don

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Quote Originally Posted by wdwells' post='791291 View Post
    ... the challenge of presenting the results of a calculation with the appropriate number of significant digits ...
    That'd be more suitable for a separate topic. You could set number format to Scientific with a number of decimal places one less than the number of significant digits, but then you always get an exponent with it. Otherwise you'd need VBA code in the Worksheet_Change or Worksheet_Calculate event.

    If you're willing to use a formula: with a number in A1, the following formula will display the value with 3 significant digits:

    =LEFT(TEXT(A1,"0.00E+00"),4)*10^RIGHT(TEXT(A1,"0.0 0E+00"),3)

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    [quote name='wdwells' post='791291' date='29-Aug-2009 11:10']But the discussion in my post was a segue into the challenge of presenting the results of a calculation with the appropriate number of significant digits (in a scientists view), without the intervention of the user.[/quote]

    I expressed some of my thoughts on using Excel for Sig Figs a number of years back...

    Steve

  11. #11
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='sdckapr' post='791310' date='29-Aug-2009 14:21']I expressed some of my thoughts on using Excel for Sig Figs a number of years back...

    Steve[/quote]

    Bullseye!!! Thank you Steve.
    Regards
    Don

  12. #12
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post
    [quote name='HansV' post='791294' date='29-Aug-2009 16:25']I could comment on that but it would violate the Lounge rules...


    That'd be more suitable for a separate topic. You could set number format to Scientific with a number of decimal places one less than the number of significant digits, but then you always get an exponent with it. Otherwise you'd need VBA code in the Worksheet_Change or Worksheet_Calculate event.

    If you're willing to use a formula: with a number in A1, the following formula will display the value with 3 significant digits:

    =LEFT(TEXT(A1,"0.00E+00"),4)*10^RIGHT(TEXT(A1,"0.0 0E+00"),3)[/quote]

    Thanks to all who replied to this post, suffice it to say, Prasad's reply was more than adequate for my requirements.

    Best Regards

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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