Comparing type double variables of different lengths

[paulmezick]

I am trying to compare two numbers of different lengths up to a certain decimal. For example, 6.01, and 6.01243434. If the numbers match I want to output "YES" in a third cell.

I figured the following would work:

Please Login or Register  to view this content.

I am running into a problem when I have a decimal that is of a certain length. Take -0.0693080388371247 for example. VBA stores this as -6.93080388371247E-02. When I attempt to compare this to my other decimal, the values do not match, even though it actually is the same number. Is there anyway I can get around this? I've attached a small workbook that demonstrates my problem.

Thanks!

[royUK]

This seems to work

Please Login or Register  to view this content.

[paulmezick]

Thanks that works great!