View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Goodall[_2_] David Goodall[_2_] is offline
external usenet poster
 
Posts: 8
Default Do Until problem

Morning
I've set up a do until loop but it doesn't stop when the two conditions
appear to be the same.

The two variable I'm comparing are declared as Double and I think that's
where the problem lies. When I debug the watches are as follows:-

Variable1 = 39779.4028
Variable2 = 39779.4028

They appear to be the same but I'm thinking that not all the decimals are
being shown. I only need the answers to 2 decimal points ie 39779.40 so
would you suggest casting the double to another variable type.

Hope this makes sense.
Thanks
David