Microsoft Excel - I have a number to 8 decimal places. The ROUND function gives the wrong results. Why?

Question

The number is 21.84856309, the cell for which, (D4), I have formatted as "number -8 decimal places" (OR "general")... both formats give the same wrong results, oddly....
I formularised a column to round (ie. up or down) this number to 1, 2 and 3 decimal places respectively.
I used - =ROUND($D$4,1), =ROUND($D$4,2) and =ROUND($D$4,3) respectively.

The answers should be 21.8, 21.85 and 21.849.
Instead, I get 21.80000000, 21.85000000 and 21.84900000. Can anyone help?

Answer 1

not sure if I am pushing you the right direction, but it sounds like you may have changed the formatting on D4 without changing the formatting on the cells actually containing the formulas.

Answer 2

while formatting , indicate the right number of decimal places. if you want 2 decimal places, choose two decimal places if you want to round to any number of decimal places, there will be no need formatting the cell rather go ahead and and use the ROUND function.

Answer 3

hi Phil, what you are getting into is java script. i know what you are thinking what is java script? java script is a new language that is into computer science so let's say that you and i are in business together so we are building condominiums three bedrooms two bath but then someone comes to us that is needing a four bedroom two bath so you get busy and make up the blueprints then my crew and i get busy to build it after the building inspector comes over to aprove our plans then we build it but the profit is always the boss. this is an example of java script. so we are building computers so we are adding up all of the parts by using java script to sum up wheather we are going to get any boss. this is complete java so it is very enteresting something for the younger generation. some people takes java script as a college major and these people is who microsoft and other computer manufacturers are hiring. good luck i hope i was helpful to you