Question Iif & And Function

[crystal2000a]

Hi,

I have a calculated field with the formula below:

Iif([Left Cathode Channel vs Cathode 1]>=0.45 And [Left Cathode Channel vs Cathode 2]>=0.45 And [Right Cathode Channel vs Cathode 1]>=0.45 And [Right Cathode Channel vs Cathode 2]>=0.45 And [Left OEE Channel vs Cathode 1]>=0.45 And [Left OEE Channel vs Cathode 2]>=0.45 And [Right OEE Channel vs Cathode 1]>=0.45 And [Right OEE Channel vs Cathode 2]>=0.45,"FAIL","PASS")

*The pass/fail is purposely set to opposite

However, although one of these measurements are out of spec, the status still states PASS. What am I doing wrong? A similar formula worked before but this doesn't seem to. I am scratching my head to figure out what it wrong. Please help.

Thanks,
Newbie

 

[James Dudden]

When you say 'one of these measurements are out of spec' what do you mean?

At the moment your formula states that if all the fields are >= 45 then the result is 'FAIL' but if one or more of your fields is < 45 then it will be set to 'PASS'.

What do you want to happen?