Could you try to rephrase the question? Either I don't understand your terms, or I cant follow your logic.
Can both fields be Yes or both fields be No?
So if field_a has a Yes or field_b has a Yes, you want the response to be 'Yes' otherwise you want the response to be 'No'
For your calculation in the req_met field (if I follow you):
Case ( field_a = "Yes" or field_b=yes; "Yes";'No")
Thanks for your post. If either field_a or field_b have a "Yes" answer, the req_met should be "Yes" and otherwise should be "No". I tested using the "MAX" function and it worked as long as either of the fields have a "Yes". I can see that it would not always work. I tried your suggestion with the "Case" statement and after several attempts it worked fine. I have since used the "Case" statement in other applications. I appreciate your comments.