Help with a logical function

[Nadia_Gorchakov]

Hi!

I’m using airtable in the hiring process (kind of like a scorecard) and I was wondering how to write a function to produce a recruitment decision based on two airtable columns.
Here’s the idea: If {column 1} = ‘accept’ AND {column 2} = ‘accept’, than ‘proceed’. Otherwise ‘no’.
Is there a way to write a logical function for that?

Thanks in advance! :slightly_smiling_face:
Nadia

[Nathalie_Collin]

Hi @Nadia_Gorchakova and Welcome to Airtable Community :grinning_face_with_big_eyes:

Try this.
IF({column 1}=“no”,“no”,IF({column 2}=“no”,“no”,“accept”))

Replace the “no”'s with whatever you’re using for the non accepted.

[Justin_Barrett]

Here’s how to do it using AND:

IF(AND({column 1} = "accept", {column 2} = "accept"), "proceed", "no")

[Nathalie_Collin]

@Justin_Barrett Thanks for posting :grinning_face_with_big_eyes:

I find myself staying away from the AND formula only because I get tripped up as to where to place them.

[Nadia_Gorchakov]

Thank you friends! :slightly_smiling_face: