What is missing in it?

[cap.zadi]

Hello Dear,

Please advise which is missing?

=(IIf([Observation]=[Leakage was not Found] Or [Observation]=[Leakage was Found],"Passed","Failed"))

thanks

zee

[stmoong]

What result are you expecting?

The logic itself seems strange, if observation is either no leakage found or leakage found, then pass??

[cap.zadi]

The logic is, if in the field of "Observation " Leakage was not found" in results fields it should be appear "Passed" and if "Leakage was found" so the results field should be filled up with "Failed"?

[stmoong]

Is the [Observation] field going to store the text "Leakage was not Found" ?

If it is, then it would be like this:
=(IIf([Observation]="Leakage was not Found","Passed","Failed"))

[cap.zadi]

The Test "Leakage was not found" is filled up from combox. this function is only applied in result field to automate the results passed or failed

[cap.zadi]

thanks, it is done.

[cap.zadi]

sorry it is only just "failed" is appearing in both cases?

[stmoong]

sorry it is only just "failed" is appearing in both cases?

Case-sensitive.

=(IIf([Observation]="Leakage was not found","Passed","Failed"))

Or, you can try the UCase function, like this:

=(IIf(UCase([Observation])="LEAKAGE WAS NOT FOUND","Passed","Failed"))