IF AND Formula with 2 criteria to comply

[JoVanEeden]

I can't get this formula to work.

My table has 3 fields:

• Agreement Signed
• WYNTK Signed
• Intake Form

Each field has a single select option, "Yes" , "n/a" or "In Progress".

I have a final field "STATUS" with a formula - should all three fields = "Yes" or "n/a" =  "✅" 

If any one of the fields = "In Progress" then the STATUS field = "❌" 

IF(

   AND(

     {Agreement Signed}="Yes",

     {Agreement Signed}="n/a",

     {WYNTK Signed}="Yes"

     {WYNTK Signed}="n/a",

     {Intake Form}="Yes"

     {Intake Form}="n/a"

   ),

   "✅",

   "❌"

)

[TheTimeSavingCo · Accepted solution]

Could you try this out?

IF(
  AND(
    OR(
      {Agreement Signed}="Yes",
      {Agreement Signed}="n/a"
    ),
    OR(
      {WYNTK Signed}="Yes",
      {WYNTK Signed}="n/a"
    ),
    OR(
      {Intake Form}="Yes",
      {Intake Form}="n/a"
    )
   ),
   "✅",
   "❌"
)

[JoVanEeden]

@TheTimeSavingCo Worked! Thank you so much! 🎉