precision calculation

  • Thread starter Thread starter Renee
  • Start date Start date
R

Renee

I NEED HELP! I need excel to add up the displayed values,
and not the stored values. I have already changed
tools/options/precision as displayed, and it is still
using the stored values, what am I doing wrong?
 
Renee,

Sounds like you need to use the "ROUND" function for your calculated
cells. =ROUND("your equation",2) The two will round it to two decimal
places. You can any number in place of the 2, depending on what your
looking for.

RAC
 
Back
Top