I am using the following formula in a cell and when I input Y into C3 I am getting #Name ? instead of "this is broken"
What am I doing wrong?
=IF(C3=Y,"This is broken", "")
If I change the formula to: =IF(C3=15,"This is broken", "") and put 15 in C3, the cell with the formula reads...