Excel 2000 : calculation error

[Sleeper]

Morning,

I get calculation errors with calculations as simple as a + or a -.
Here is an example :
type in a cell =1.245-1.155
the result should be 0.09, but is 0.0900000000000001.
Then a round formula is compulsory to use some others such as
IF(cell=0.09,....).

Is it possible to fix this error?

 

[Nick Hodge]

You'll find that no computer can accurately represent floating point
numbers. This way you will get rounding errors at the extremities of
precision.

To overcome this totally you either have to use ROUND, as you have already
found or Tools>Options...>Calculation>precision as displayed. This will
cause excel to use only the formatted precision

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Sleeper]

Thank you Nick for your explanation.

You'll find that no computer can accurately represent floating point
numbers. This way you will get rounding errors at the extremities of
precision.

To overcome this totally you either have to use ROUND, as you have already
found or Tools>Options...>Calculation>precision as displayed. This will
cause excel to use only the formatted precision

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)