A1=1.2675-1.2664=.0011 B1=1.2664-1.2653=.0011 Is A1=B1? Excel's answer is: False; Question: why?
Z Zeno Jul 11, 2006 #1 A1=1.2675-1.2664=.0011 B1=1.2664-1.2653=.0011 Is A1=B1? Excel's answer is: False; Question: why?
B Bob I Jul 11, 2006 #2 Use the Trunc function on the two sets. B1 is not quite ".0011" but ".0010999" TRUNC(1.2664-1.2653,7)=.0010999
Use the Trunc function on the two sets. B1 is not quite ".0011" but ".0010999" TRUNC(1.2664-1.2653,7)=.0010999
