1 Reply Latest reply: Nov 14, 2012 4:55 AM by Wayne Contello
Jvorobey Level 1 Level 1 (0 points)

How to set Precision as displayed in cells?

 

Presicion as displayed.png


MacBook Pro (Retina, Mid 2012), OS X Mountain Lion (10.8.2)
  • Wayne Contello Level 6 Level 6 (15,195 points)

    there is a function called round() that can assist in rounding to a specified place.

     

    In trying to duplicate your result it became clear that the numbers you were multiplying were not what you have shown here.  In row 7 the dislayed values are rounded in column D.

     

    This problem comes up often here becuase there is a difference between the value in the cell AND the value Numbers displays.  youn should round all numbers in all calculations to the number of places you want by using the round function.

     

    In D7 it is clear you applied visual rounding by the number itslef that is stored in the cell has many decimal places.the values in column D should be calculated as follows:

     

    Screen Shot 2012-11-14 at 6.54.15 AM.png

     

    I just duplicted that portions of your table that I needed:

    D7=ROUND(D2*$E$5, 2)