IF Statement nightmare

E

eugenevr

User's IF statement doesn't work. If the user logs onto another PC,
that same IF statement is fine. If another user logs onto the PC, the
*same* statement runs fine.

I just don't get it!
Any suggestions welcome...

Eugene
 
D

Doug

The statement may contain a function that is not available because an Add-In
is not ticked. Analysis ToolPak and Analysis ToolPak - VBA are the Add-Ins
that most often need ticking.

Doug

eugenevr wrote in message
 
E

eugenevr

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

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

Thanks for your help!
 
J

Jerry W. Lewis

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
 
Top