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.

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.

Hi, Peo, I just wanted to say thanks for your response. :) I haven't used
either ROUND or Precision as displayed much in the past but they do seem to
round the same way, at least for what I'm doing right now.

Thanks again! :)


"Peo Sjoblom" wrote:

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.