Calculated column to display Y/N if text col = text col 2

7 views
Skip to first unread message

kaoste...@gmail.com

unread,
Nov 12, 2015, 12:00:50 PM11/12/15
to
Here's my scenario:

Column A contains 3 alpha characters (i.e. ABC).
Column B contains 3 alpha characters as well (i.e. ABC).
Column C should display "Y" if column A = column B or "N" if column A DOES NOT = column B.

I created Column C as a calculated column using the following formula:

=IF([Column A]=[Column B]), "Y", "N"

with data type returned from this formula is: Single line of text, but I get an error message "The formula contains a syntax error or is not supported."

Is there a way to achieve this? What is the formula?

Chris

unread,
Nov 13, 2015, 2:17:11 PM11/13/15
to
You just have the parentheses in the wrong place:

=IF([Column A]=[Column B], "Y", "N")
Reply all
Reply to author
Forward
0 new messages