round problem

[Keesb]

When I do the following:
A1 = ? 1743.14
A2 = ? 9940.34
A3 = ? 10855.77
A4 = "=A1+A2-A3"

The result is 827.71
But when i put my cel properties on 20 decimals I get this result
827.709999999999

How is this possible?

Kees

 

[Niek Otten]

Hi Kees,

http://support.microsoft.com/kb/78113

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| When I do the following:
| A1 = ? 1743.14
| A2 = ? 9940.34
| A3 = ? 10855.77
| A4 = "=A1+A2-A3"
|
| The result is 827.71
| But when i put my cel properties on 20 decimals I get this result
| 827.709999999999
|
| How is this possible?
|
| Kees
|
|

 

[Keesb]

Thanks Niek.