rounding error?
Regardless of how the cell has been formatted, cell A1 still contains the
value of 5.0568725. To get a zero you would have to round the number in cell
A1 to 4 decimal positions"
=ROUND(5.0568725,4)
--
Kevin Backmann
"Steve" wrote:
A1 = 5.0568725
B1 = 5.0569
C1 = Round(A1,4)-B1
Why doesn't C1 give me a zero value?
|