Rounding and Precision Errors

[hilss]

Hello,

In Excel/VBA, I have variables: Q and R. They are both a function of x (complicated formula - but no need to describe it here).
D = Q^3 + R^2

So I have:
x in column A
Q in column B
R in column C
D in column D

At one point, Q^3 so small that D = R^2. I am adding a small number (Q^3) with a big number (R^2).

If I graph D vs x, I see a drop in the graph of D (a discontinuity). I'm wondering if there's a way to make this drop smoother.

D is later used to compute other things. This discontinuity in D affects the remaining results.

The values of Q and R can vary a lot. So it's not like they stay in a certain range.

Thanks,
hilss

 

[Ruddles]

How did you DIM those variables?

 

[hilss]

as double