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

Printable View

- October 26th 2010, 08:56 AMKayPeeRounding 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 - October 26th 2010, 02:56 PMHallsofIvy
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. - October 26th 2010, 03:07 PMemakarov
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.

Quote:

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

- October 28th 2010, 11:33 AMKayPeethe Questuon in Excel!
hey am confused

this is my question in excel.

Thanks

K - October 28th 2010, 12:51 PMemakarov
The prices in the Excel sheet are already rounded to the nearest sixteenth. What is your question?