Comparing two Double values not working some times
I am running into issue when comparing two Numeric Double values. I am extracting one value from text and converting to CDbl. And other value is calculated and converted to CDbl. Since I want to keep the digits at the end as is, comparison works some time and some time it fails. I can't keep the values in integer since It will round off. How can I make this work every time I compare the values.
Comparison Works some times:
if 8000.113 = 8000.113 then
this works fine every time:
if 563996 = 563997 then