Assistance with Modifying A Formula

[John_Dlouhy]

Greeting Airtable Community!

I have an existing formula that is returning the correct results:

IF(AND({Guest Code}=‘DONOR’,{Status S2}=‘Yes’),First&" "&Last)

I now need to modify the formula to include {Status S2}=‘Yes FUP’ and the ‘Yes’ variable.

Any assistance on this would be greatly appreciated, as always.

John

[Jeremy_Oglesby]

Can you clarify – do you want to require that {Status S2} contains BOTH “Yes FUP” AND “Yes”, or EITHER “Yes FUP” OR “Yes”?

[John_Dlouhy]

Thanks Jeremy. I’m sorry I didn’t clarify that. It would be
EITHER ‘Yes FUP’ or ‘Yes’.

[Jeremy_Oglesby]

This should do it:

IF(
   AND(
      {Guest Code}='DONOR',
      OR(
         {Status S2}='Yes',
         {Status S2}='Yes FUP'
      )
   ),
   First&" "&Last
)

[John_Dlouhy]

Thanks Jeremy! I will try this now!!