Wrong Round

[Ana]

There is a cell that is a sum of 5 cells upper, the 6
cells are formatting with 2 decimals. But the sum is
rounding up , it should show ,36 but the result showed
is ,37. How can I resolve this ? thank you very much in
advance.

 

[Frank Kabel]

Hi Ana
the cells from aboth are probably not rounded but only DISPLAYED with
two decimals. You may round each cell with something like
=ROUND(formula,2)

For more details about this see:
http://www.cpearson.com/excel/rounding.htm

 

[Anne Troy]

It's unlikely that it's rounding wrong. Can you provide the exact values
that are being rounded, and what they are rounding to?
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[Guest]

Thank you very much, I resolve the problem reading the
article and activating Tools/Calculate/Prescision as
display
Thank you very much.