Forum Discussion
Why Simple Formula Adding Two Cells Won't Work?
Floating point operations usually give side effect around zero result expected, especially with logical operations. Well known example is
=1*(0.5-0.4-0.1)
which returns -2.78E-17. With this
=(1*(0.5-0.4-0.1)=0) returns FALSE however =( (1+1*(0.5-0.4-0.1))=1) returns TRUE
Hi Anastasiya,
Do you mean the result of E20 + G20 is showing up as zero? If yes, then that is simple arithmetic. Assuming E20 has 5 and G20 has -5, E20 + G20 = 5+(-5) = 5-5 = 0.
If you have a different view of what you are asking for, you might want to share a screenshot of an example.
Thanks,
Bala..
Not, of cause it is not so simple. 0, that what I expected it to be, and there was something strange. And actually may be this is not so simple formula as I called it, as in first cell was formula as well. But I just remembered something from years ago, and figured it.
Floating point operations usually give side effect around zero result expected, especially with logical operations. Well known example is
=1*(0.5-0.4-0.1)
which returns -2.78E-17. With this
=(1*(0.5-0.4-0.1)=0) returns FALSE however =( (1+1*(0.5-0.4-0.1))=1) returns TRUE
Hi. Thank you, Sergei!
It looks like what I was getting.
I wonder why changing columns could give regular result?
Thank you!