IF Statement nightmare

[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

 

[JE McGimpsey]

Any suggestions welcome...

Post the IF statement...

 

[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

 

[eugenevr]

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

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

Thanks for your help!

 

[Mangesh]

what does it run on the offending pc?

Mangesh

 

[Mangesh]

Sorry, I meant what does it return on the offending machine

Mangesh

 

[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