IF Statement nightmare
 

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

Any suggestions welcome...

Post the IF statement...


In article .com,
"eugenevr" wrote:

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

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
.com...
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

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

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

Thanks for your help!

what does it run on the offending pc?

Mangesh


"eugenevr" wrote in message
oups.com...
The statement really is quite simple, here is a test entry:

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

Thanks for your help!

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

Mangesh


"Mangesh" wrote in message
...
what does it run on the offending pc?

Mangesh


"eugenevr" wrote in message
oups.com...
The statement really is quite simple, here is a test entry:

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

Thanks for your help!

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!