It would be great if had (at least the choice for) scaled integer
arithmetic, like in some programming languages. Maybe it could be applied
automatically if cells are formatted as currency.
Anyway, it could be done better than it's done now, indeed not at all the
way we think about numbers.
I've put it on my wishlist to MS, but I'm not too optimistic.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


"Harlan Grove" wrote in message
...
"Dana DeLouis" wrote...
...
Sometimes if you break the calculation up, Excel may be able to round
these
errors earlier. For example, both:
=(A1+A2)+(A3+A4)
and
=A1+(A2+A3+A4)
return 0
...

The reason is that finite precision floating point addition isn't
associative.