compare values
Increase the number of decimal places shown for cells E1 and E2 and
you will see that they are not exactly equal. This is a common problem
with computers which use binary numbers to represent decimals - some
decimal fractions cannot be represented exactly with binary fractions,
and so rounding errors occur.
I'm sure that JoeU will give a more detailed explanation.
Hope this helps.
Pete
On Sep 21, 4:23*pm, Steve wrote:
I have a problem in a macro where I'm comparing two values. *They appear to
be the same but when tested in the code, are different. *I recreated the
problem using this scenario:
A1-D1 = .2003, .0542, .0257 and 0, respectively.
A2-D2 have the same values.
E1 = .2802
E2 = the formula sum(A2:D2)
When I run the following code I get the message box values ".2802", ".2802"
and "False". *The funny thing is...if I type a formula in the worksheet
=E1=E2 I get "True":
Sub testit()
frst = Range("E1").Value
Scnd = Range("E2").Value
MsgBox frst
MsgBox Scnd
MsgBox (frst = Scnd)
End Sub
|