So Excel cannot do subtraction

[NukedWhale]

Try it for yourself. Subtract 3.63 from 3.64 in excel. You should see a correctly displayed answer of .01; but if you increase the decimal places out far enough, you'll find a random number.

So if you have any formulas tied to that number they can incorrectly evaluated because of it.

Anybody know any workarounds or spreadsheets that do not have random floating numbers?

The explanation why Excel does this is here:

http://www.dailydoseofexcel.com/archives/2...nary-fractions/

[jaclaz]

I don't see the problem.

Just use the round() function to the desired precision, which is (or should be) common practice.

Alternatively, somewhere in options there is a "set precision as displayed" or something similar.

jaclaz