Any good ways for comparing two floats?

HI,

I am reading cells from two different excel files and comparing the values in them.

For one cell, the values I am comparing are 399.99999998 and 399.99999999.

I would like to compare both numbers, and if the difference is greater than 0.0000001, ignore the difference.

The problem I am having is, when I get the ABS of num1 - num2, this gives me 1.0000007933E-8.

Is there any good way to compare floats without getting E numbers? I am using vbscript.

Thanks in advance! 🙂