AnsweredAssumed Answered

Using AND operator in a case function

Question asked by wcallman on Jul 21, 2018
Latest reply on Jul 21, 2018 by wcallman

Okay, my next, why doesn't it work question:

 

Field name: Marital Status is set as a radio button with 5 potential marks of which one is single.

Field name: A1_Fam Parent is set as a radio button Yes or No

If both fields are marked yes, I need to return in a text Y

If either field is marked no, or blank I need to return N

 

The case function I currently have is:

Case(Marital Status="Yes" and A1_Fam Parent="Yes"; "Y";"N")

 

This formula always returns N.

 

I have tried:

Case(Marital Status="Yes" and A1_Fam Parent="Yes"; "Y";"N";"")

If(Marital Status="Yes" and A1_Fam Parent="Yes"; "Y";"N";)

without success.

 

Any thoughts?

Outcomes