Hello
This is something that has happened to me some times but never understood why.
I'm doing a simple calculation which I can easily do in my head, and the answer should be 0 but excel returns a negative 0.
Upon further inspection the 14th decimal position has a value, but it should be 0.
Anyone knows how to correct this? (tried it in 2 computers with the same result)
<tbody>
</tbody>
This is something that has happened to me some times but never understood why.
I'm doing a simple calculation which I can easily do in my head, and the answer should be 0 but excel returns a negative 0.
Upon further inspection the 14th decimal position has a value, but it should be 0.
Anyone knows how to correct this? (tried it in 2 computers with the same result)
1 | 2 | 3 | 4 | ||
A | 7212.50 | 4141.25 | 2907.01 | 164.24 | +A1-A2-A3-A4 |
<tbody>
</tbody>