What is in A1 and A2? As a guess, the use has "Precision as Displayed"
checked, so that cell formatting is changing the interpretation of
formula results.

Jerry

eugenevr wrote:

The statement really is quite simple, here is a test entry:

=IF(A1=A2,"t","f")

Thanks for your help!