change the format of all the cells including result to Number with 2
decimals. It will be zero then. I suppose currently the cells are of general
format.

The sum was 0 on my PC after I changed the formatting.
Hope this helps.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Rajneesh Arora" wrote:

enter following numbers in worksheet (in same sequence)
14189.05
-13605.77
-544.23
-39.05
sum of above
The answer(sum) should be exactly zero. But the answer computed and
displayed is -1.1795E-12
Now change the sequence of numbers and sum them. Answer will be exactly zero.
Any ideas, whats the reason.
Any solution to overcome this - I want to reach an answer of exactly zero
(without changing the sequence).
There are many other combinations of sums in which there is a similar problem.
Please help.