ExcelBanter - rounding and comparing cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - rounding and comparing cells (https://www.excelbanter.com/excel-discussion-misc-queries/141809-rounding-comparing-cells.html)

BSantos

rounding and comparing cells

Does anyone know how to format this.

If I have in one cell $21.40 and I have another cell I'm comparing that cell
to to give me a result that has $21.3980506 in the cell. My question will not
say they match because of the string of #'s after the .39. I need to change
all the cells in that column to be only 4 digits and rounding up if necessary.

Does anyone know an easy way to do this?

Thanks, B.

Toppers

rounding and comparing cells

=ROUND(A1,2)

where A1=21.3980506

"BSantos" wrote:

Does anyone know how to format this.

If I have in one cell $21.40 and I have another cell I'm comparing that cell
to to give me a result that has $21.3980506 in the cell. My question will not
say they match because of the string of #'s after the .39. I need to change
all the cells in that column to be only 4 digits and rounding up if necessary.

Does anyone know an easy way to do this?

Thanks, B.

All times are GMT +1. The time now is 05:43 AM.