Skip navigation

Precision as displayed

172 Views 1 Reply Latest reply: Nov 14, 2012 4:55 AM by Wayne Contello RSS
Jvorobey Calculating status...
Currently Being Moderated
Nov 14, 2012 1:44 AM

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 (12,625 points)
    Currently Being Moderated
    Nov 14, 2012 4:55 AM (in response to Jvorobey)

    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)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.