CODEWITHSUNDEEP
excelexcel-formulams-office
Kuldeep Choudhary
Kuldeep Choudhary

Reputation: 775

Showing incorrect sum in excel row sum formula

Formula =(N59 -O59 - P59 - R59)

working fine for most rows but for some rows, the sum is 0 - but it is showing a strange value like -7.27596E-12

I have tried many thing but I don't know what I am missing

Upvotes: 0

Views: 773

Answers (1)

cxw
cxw

Reputation: 17041

Because computer math isn't exact in decimal, so 0.1+0.9 is not necessarily exactly 1.0. The notation "E-12" means "times ten to the minus twelfth," which is tiny.

Here's a forum thread on the subject, and here's the official Office documentation. If you change the cell format from General to Number, you can set how many digits you want. E.g., if you select 2 digits, 0.001 or anything smaller will round down to display as 0.

enter image description here

Upvotes: 3

Related Questions