View Single Post
  #2   Report Post  
bpeltzer
 
Posts: n/a
Default An Inquirey on the Round function

The result of the round function only has as many significant digits as
specified in the function. Demo: enter 4.52 in cell B5, =round(b5,1) in
cell c5. In B6, =b5*100. In c6, =c5*100. The round function hasn't changed
the value in its precendent cell (b5), but only has one significant digit in
its result in c5.

"PA" wrote:

Couldnt find the answer with extensive searches:
Does the Round function round the number of significant digits stored in a
cell, or does it round the number displayed?
I believe it to be the latter, but need confirmation.

Thank you.