If calculation not returning correct results!

[stephiesmith1]

I can't figure out what I'm doing wrong. The fields called Condition A thru D are using check boxes for "Yes" (blank for nothing). I want the text to display red when no conditions are met (this is working). I want the text to display green when Condition D is met (this is working). What doesn't work is getting the text to change to blue when Conditions A,B, and C are met.

I keep getting either red or green, even though I have ConditionA, ConditionB and ConditionC (but not D) checked for Yes.

Does anyone know what I'm doing wrong?

If ( ConditionA = "Yes" & ConditionB = "Yes" & ConditionC = "Yes" ;

TextColor ( Employees::Name ; RGB ( 0 ;0; 255 ) ) ;

If ( ConditionD = "Yes"; TextColor ( Employees::Name ; RGB ( 0 ; 255; 0 ) );

TextColor ( Employees::Name ; RGB ( 255 ; 0; 0 ))))

[stephiesmith1]

Well, who's dumber than me? I switched the "&" to "and" and it works. I don't know that the rule is behind that, i.e., when to use "&" and when to use "and"; I was just trying everything I could think of. Anyway...never mind!

[mr_vodka]

stephie.

The '&' is for concatenation. It links text, numbers, variables, formulas, etc together.

The 'and' is used for logical interpretations.

[BrentHedden]

Ahh - John beat me to it. I perform this silly mistake every now and then too. I wish FM would make the logical conditions UPPERCASE, thus making it a bit easier to read.

[stephiesmith1]

Thanks, Brent and Mr. Vodka. Hopefully, I will remember this!

Stephie