AnsweredAssumed Answered

Case Statement  or Nested IF Statement

Question asked by BerkleyKeen on Dec 17, 2014
Latest reply on Dec 19, 2014 by BerkleyKeen

Title

Case Statement  or Nested IF Statement

Post

I am trying to create a calculated field (req_met) based on a "Yes" response to either field_a or field_b. If field_a has a "Yes" response, I want a "Yes" response input to calculated field (req_met) and no further tests are required. If field_a has a "No" response, I want to test field_b for a "Yes" or "No" response. If field_b has a "Yes" response, I want a "Yes" response input to req_met. Otherwise, I want a "No" response input to req_met. I have tried several calculations using "IF" statements and "Case" statements, however; I am not getting the correct responses. I appreciate any comments or suggestions.

 

DBK

Outcomes