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