Thread: Logic Test ?
View Single Post
  #2   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 A1=1.2675-1.2664=.0011
B1=1.2664-1.2653=.0011
Ask A1=B1, result is False; why?