Looking up the rounded value in a cell, not linking to the value.

J

John Wirt

What function will look up the rounded value appearing in a cell, rather
than the value including all digits of precision.

Suppose cell A31 has this value in it: 34.23942498747
And the value is rounded in that cell to 2 digits: 34.24

What function can I enter in cell A2 to reference the value in cell A31 and
display its rounding value in A2?

This seems like an Excel 1.0 question but I do not know the answer.

Thanks.


John Wirt
 
R

Ron Rosenfeld

What function will look up the rounded value appearing in a cell, rather
than the value including all digits of precision.

Suppose cell A31 has this value in it: 34.23942498747
And the value is rounded in that cell to 2 digits: 34.24

What function can I enter in cell A2 to reference the value in cell A31 and
display its rounding value in A2?

This seems like an Excel 1.0 question but I do not know the answer.
Click to expand...

=ROUND(A31,2)


--ron
 
B

Bob Umlas, Excel MVP

=ROUND(A31,2)

----- John Wirt wrote: -----

What function will look up the rounded value appearing in a cell, rather
than the value including all digits of precision.

Suppose cell A31 has this value in it: 34.23942498747
And the value is rounded in that cell to 2 digits: 34.24

What function can I enter in cell A2 to reference the value in cell A31 and
display its rounding value in A2?

This seems like an Excel 1.0 question but I do not know the answer.

Thanks.


John Wirt
 
Top