S
Steve
A1 = 5.0568725
B1 = 5.0569
C1 = Round(A1,4)-B1
Why doesn't C1 give me a zero value?
B1 = 5.0569
C1 = Round(A1,4)-B1
Why doesn't C1 give me a zero value?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin B
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)
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)
M
muddan madhu
Go to format cell | number | category | number | decimal places 0 | ok
S
Steve
In my C1 formula why doesn't "round(a1,4)" calculate a value of 5.0569 so
when I subtract 5.0569 I get zero?
when I subtract 5.0569 I get zero?
K
Kevin B
Initially I overlooked your formula when I responded the first time but I've
not been able to replicate your answer. I'm using Excel 2003 and regardless
of where I do the rounding I'm getting 0
not been able to replicate your answer. I'm using Excel 2003 and regardless
of where I do the rounding I'm getting 0
J
Jerry W. Lewis
My guess is that B1 is the result of a calculation an that =(B1-5.0569) is
not zero.
Computers do finite precision math, so rounding errors can accumulate.
Consequently, with floating point values you should test whether
ABS(x-y)<epsilon, instead of whether x=y.
not zero.
Computers do finite precision math, so rounding errors can accumulate.
Consequently, with floating point values you should test whether
ABS(x-y)<epsilon, instead of whether x=y.