Formula answer is rounding when it shouldn't

I'm working on a Project Manager cheat sheet for class and one formula is giving me fits because it keeps rounding the answer to the nearest 1,000. I want it to divide the value in one cell (C8) by the value in another (C14), but the only way I can get the answer to come out accurately is by manually typing in what the values of those cells are into a calculation formula in the target cell.
I've started a new spreadsheet and manually entered all the data, I've verified there's no rounding of the cell, and I still can't figure out why it's rounding it.
I've also tried to attach the file to this but the site won't let me. When I drag and drop it puts it in my download folder and when I select the "attach file" option I get a really small white window that doesn't stretch or do anything.
The values in C8 is 100,000 and the value is C14 is 0.95. I want to take C8/C14 which should be 105263.1579 but it keeps giving me 105000.00 as the answer.
Regards,
Nanaia

Click on Edit post or Reply to Thread or Go advanced to bring up the advanced post editing page. Below the editor should be a "manage attachments" link that will bring up the functional file uploader. You should then be able to attach your file. In this case, I think it will be necessary, because I cannot recreate this behavior on my own, so I expect it is something specific to your file that we will need to see in order to debug.

Originally Posted by Nanaia

The values in C8 [errata: B8] is 100,000 and the value is C14 [errata: B14] is 0.95. I want to take C8/C14 which should be 105263.1579 but it keeps giving me 105000.00 as the answer.

B14 only appears to be 0.95 due to the cell format. If you format to display 15 decimal places, you will see that B14 is actually 0.952380952380952. And 100000/0.952380952380952 is indeed 105000.

Also note that B10 only appears to be 33333.33 due to the cell format. It is actually 33333.3333333333.

Perhaps you should explicitly round some or all formulas to the precision that you want: 2 decimal places for dollar amounts; perhaps 2 decimal places for CPI and SPI as well. For example, in B10: =ROUND(B8*(B3/B2),2); and in B14: =ROUND(B10/B11,2).

I think the main reason is the actual value of C14 is 0.9523809524 instead of 0.95000000 (you can try to add decimal behind to check the value)

Since the C14 is a formula as well, I believe the 105,000 should be a more accurate value.

If you want the C14 actual value is 0.95 instead of 0.95238.... you can add in Rounding formula,
there have 3 rounding formula, is up to your choice.

=Roundup(C10/C11,2)
(ie 1.001 > 1.01)

=Round(C10/C11,2)
(ie 1.004 > 1.00, 1.005 > 1.01)

=Rounddown(C10/C11,2)
(ie. 1.0099 > 1.00)