If statements in Excel with cells containing CJK characters

Question

I am trying to make an IF statement in Excel 2016. My spreadsheet has Japanese characters, and I need to make a comparison like

=IF(A2="ア", TRUE, FALSE)

However, the function always returns false, even when A2 actually contains katakana ア.

Answer 1

I installed the Japanese language pack like @Tom mentioned, selected Japanese as the default editing language and it works fine. Thank you, Tom!