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

[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

 

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

=ROUND(A31,2)


--ron

 

[Guest]

=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