I believe they will round the same way. Of course there are things that
never will be "correct"

A1 holds 1
A2 =A1/3
A3 =A1/3
A4 =A1/3

if you format with 2 decimals and then apply precision as displayed then
=SUM(A2:A4) will return 0.99 the same way as if you used

=ROUND(A1/3,2)

and so on

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"bb" wrote in message
...
What is the difference between using ROUND and "Precision as displayed"?
When should you use one and when the other?

For instance, if I have 0.53 + 0.53 = 1.06 and the cells are formatted to
show only 1 decimal place, it would look like this: 0.5 + 0.5 = 1.1, which
looks incorrect. Would it be better to use ROUND or "Precision as
displayed"
to make it show 0.5 + 0.5 = 1.0? It seems as though using ROUND or
"Precision as displayed" yields the same results visually, at least in
this
simple example. I know that with ROUND the hidden decimals places are
still
there and with "Precision as displayed" they would be permanently deleted,
but are there any other differences between the two when it comes to how
Excel calculates numbers?

Thank you in advance for any information.