0

I have three cells with values

F5 = 85647846.76
G5 = -1229847.66
H5 = 84417999.1

In "Format Cells" the decimal places is kept as 30.

But in a new column when I do =SUM(F5 +G5 -H5) , instead of 0 I get "1.49011611938477E-08" . Is there any setting that I need to do to get the Sum as 0?

BigBen
  • 46,229
  • 7
  • 24
  • 40
user1907849
  • 960
  • 4
  • 19
  • 42
  • You will find [this article](https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/) helpful :-) – Justyna MK Oct 13 '20 at 15:36
  • I get zero as well. F5 + G5 = H5. Unless we are talking about extreme decimal points? But that would not show up with the figures you have supplied. – Davesexcel Oct 13 '20 at 15:39

1 Answers1

0

Rather than using =sum(f5+g5-h5)

replace it with =f5+G5-H5

Worked for me...

enter image description here

Isolated
  • 5,169
  • 1
  • 6
  • 18