Forum Discussion
Solved
Why Simple Formula Adding Two Cells Won't Work?
Hi. Could you please advise, why so simple formula like =E20+G20 won't work in case if number in cell G20 negative, but same value as in E20? In case of other number combinations it works.
Than...
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
I guess the formula works, result is not as you expected.
As variant that could be floating point error, e.g.
http://www.excel-easy.com/examples/floating-point-errors.html
http://excelunplugged.com/2014/05/19/15-digit-limit-in-excel/