Conditional formatting to ID identical fields

[Dena_Mendelsohn]

I want to create an airtable column that will say Yes if two other columns are identical, say No of those other columns are not identical, and say N/A if one of the columns is empty. Is there a way to do this?

For example:
Column A says Cow
Column B says Cow
So conditionally formatted Column C says Yes

Column A says Cow
Column B says Duck
So conditionally formatted Column C says No

Column A says A
Column B is blank
So conditionally formatted Column C says N/A

I’ll take any solution, doesn’t have to be conditional formatting.

Thanks ahead!

[ScottWorld · Accepted solution]

Welcome to the community, @Dena_Mendelsohn! :slightly_smiling_face:

This formula should work for you:

IF(
AND(A,B),
IF(A=B,"Yes","No"),
"N/A"
)

[Dena_Mendelsohn]

Thanks @ScottWorld! If my columns are actually sentences (rather than “A” or “B”) do I just put the sentence column name in {brackets}? Very much appreciate your help on this!

[ScottWorld]

Yes, that’s correct!

[Dena_Mendelsohn]

This works! Thank you @ScottWorld!