Results 1 to 5 of 5

Math Help - Rounding Figures(Prices of shares) to the nearest sixteenth!

  1. #1
    Junior Member
    Joined
    Jan 2009
    Posts
    64

    Rounding Figures(Prices of shares) to the nearest sixteenth!

    Hello,

    1.How do we round prices to the nearest sixteenth?-what's the essence of this rounding?

    2.How can we then get prices(rounded to the nearest sixteenth) to show as fractions in sixteenths.

    Thanks

    K
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor

    Joined
    Apr 2005
    Posts
    15,595
    Thanks
    1420
    1/2= 0.5, 1/4= 0.5/2= 0.25, 1/8= 0.25/2= 0.125, 1/16= 0.125/2= .0625

    1/16= 0.0625

    2/16= 0.125

    3/16= 0.1875

    4/16= 0.25

    5/16= 0.3125

    6/16= 0.375

    7/16= 0.4375

    8/16= 0.5

    9/16= 0.5675

    10/16= 0.625

    11/16= 0.6875

    12/16= 0.75

    13/16= 0.8125

    14/16= 0.875

    15/16= 0.9375

    Round to the nearest of those decimals and replace by the fraction.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    MHF Contributor
    Joined
    Oct 2009
    Posts
    5,530
    Thanks
    774
    Divide the fractional part of your number by 1/16 = 0.0625 and round the result to the nearest integer. That would be the number of sixteenth.

    How can we then get prices(rounded to the nearest sixteenth) to show as fractions in sixteenths.
    I am not sure I understand the question. E.g., 2 3/16 = 35/16.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Junior Member
    Joined
    Jan 2009
    Posts
    64

    the Questuon in Excel!

    hey am confused

    this is my question in excel.

    Thanks

    K
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

  5. #5
    MHF Contributor
    Joined
    Oct 2009
    Posts
    5,530
    Thanks
    774
    The prices in the Excel sheet are already rounded to the nearest sixteenth. What is your question?
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Significant Figures and Rounding
    Posted in the Algebra Forum
    Replies: 4
    Last Post: October 12th 2011, 02:00 PM
  2. Replies: 3
    Last Post: October 18th 2010, 08:48 AM
  3. Shares and Dividend
    Posted in the Business Math Forum
    Replies: 0
    Last Post: March 22nd 2010, 09:30 PM
  4. Shares of Stock
    Posted in the Algebra Forum
    Replies: 2
    Last Post: March 27th 2009, 11:13 AM
  5. Rounding up to nearest whole number
    Posted in the Algebra Forum
    Replies: 4
    Last Post: February 15th 2006, 12:04 AM

Search Tags


/mathhelpforum @mathhelpforum