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.
|