SumProduct Problem

[LAF]

The SumProduct does not seem to be working correctly when the sum of numbers in one range is equal to 0. I have 2 sets of numbers. In the first set, the user has entered the following numbers:
-3196414.12, 799103.53, 799103.53, 799103.53, 799103.53

The second set of numbers is just a flag where all of them contain a 1:
1, 1, 1, 1, 1

The following formula results in an actual number instead of 0. It results in 0.000000000232830643653870000000.

=SUMPRODUCT(A7:E7,A8:E8)

When I do it manually, I get 0. Do you know why I'm getting a number using this formula? Is there a way to get the correct number, which should be 0?

[daddylonglegs]

This is caused by the floating point arithmetic that excel uses, see here

To get zero you probably need to use ROUND function to round the result, e.g.

=ROUND(SUMPRODUCT(A7:E7,A8:E8),2)