I have three columns.
Column B contains the symbol ê or the cell is left blank;
Column C contains the letter “X” or is left blank.
If both columns contain both symbols then I want Column A to
contain the symbol “@”.
I have tried the following formula without success.
=If( B1=”ê” and C1=”X”,”@”)
All suggestions are appreciated.
Bookmarks