Thread
:
Excel Bug - Excel Geeks Unite!!
View Single Post
#
2
Jim Cone
Posts: n/a
See...
http://www.cpearson.com/excel/rounding.htm
"Joey Bag O" <Joey Bag
wrote in message
...
Ok here is whats going on,
227.82 227 0.75 0.05 0.02 227.82 False
inputed 227.82
then sum 227+.75+.05+.02=227.82
then the last cell is an IF THEN statement
If cell1 - cell5 = 0 then display True (ie 227.82-227.82=0 then "True")
Tell me why excel insists that this statement is false??
Reply With Quote