IF() Function and strings

[nepheron]

I'm having a problem with the IF function and comparing string values. For
example:

=If("qwerty"="qwerty", "TRUE", "FALSE")

Now this example should return "TRUE" as you expect, which it does. However
change the formula to =If("qwerty"="xyz", "TRUE", "FALSE") and it still
returns "TRUE". If you use integers like "If(1=1, "TRUE","FALSE") it works
fine.

I'm using Visio 2007 and am using this formula in a text field.

Any ideas?

 

[David Parker]

String comparisons are done with the STRSAME() function. Numeric functions
use the =

 

[nepheron]

Many thanks David. That fixed the problem.

Cheers