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

[kaoste...@gmail.com]

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]

You just have the parentheses in the wrong place:

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