I have a formula (see below) in a spreadsheet that should return the sum. Instead it returns an error because instead of the sum equaling zero, it equals 0.000000000014551915228366900000. The numbers that it is summing are typed and only have 2 decimal places. Rounding should not be an issue.
Does anyone have any idea why it is not returning zero?
Formula:
=IF(SUM(A1:A6)=C1,SUM(A1:A6),"error")
(I also attached the spreadsheet for review)
Thank you for your help!
Bookmarks