View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Logic Test ?

hi Zeno,

try to use round to see it as true
the results of the formula a

a1 = 0,0011000000000001
b1 = 0,0010999999999998

so they are not equal.

use =round((1.2675-1.2664),4)
and =round((1.2664-1.2653),4)

hth
regards from Brazil
Marcelo

"Zeno" escreveu:

In Excel 1.2675-1.2664=.0011= A1
1.2664-1.2653=.0011=B1
Ask if A1=B1 result is False: Why?