"For Loop" Problem...is it a bug?!

Replies to This Discussion

Permalink Reply by Giulio Piacentino on June 2, 2010 at 3:04am

Hi Justin,

it's not a bug, it's normal. In the real world (as opposed to in mathematics), it's difficult having an infinite-precision representation of all numbers. So, floating point numbers are approximations of real values. You should take this into account: there might be rounding errors when adding two floating point values.

If you do not want rounding error sum ups, one way is to re-calculate the final value every time and loop over an integer value. Here an example:


For i = 0 To arrCount
'value = start + (increment * steps)
dblA(i) = (-5) + (.4 * i)
Next


I hope this helps,

- Giulio

Attachments:

• rounding.ghx, 34 KB

Permalink Reply by Justin Diles on June 2, 2010 at 5:26am

Giulio: Thank you for the explanation and example. Makes sense. Best, J