Run-time error 6: overflow

Hi guys,

i hope you can help.

I make use of this simple method for doing some calculations.

The only problem is that when my variables are zero (0), I get a Run-time error 6: overflow. I think it has to do with dividing 0 with 0, or something like that. Any ideas how I can overcome this?

Please Login or Register  to view this content.

Thank you!

Hi AB33

Thanks will test now. Just changed my declarations from Double to Long, but the got error: 11 - division by 0.

will revert!

I know!

I have done i like this:

Please Login or Register  to view this content.

Is this mathematically correct? I.e., the fact that I decide g = 0 when my divider = 0?

I suppose I could also say the following:

g = "No Calculation"

AB33

That won't work as both the True and False expressions in Iif are evaluated.

Hi Norie,

And my simple solution?

Please Login or Register  to view this content.