Forum Discussion
Solved
Does anyone know how to: Cell A1 = Cell A2, enter (checkmark) in Cell A3?
And if not equal, enter an "X"? I tried inserting symbols and wingdings in an IF statement, and could not get them to work. Only normal text would work. Please help.
Wow. That is quite the formula. I have never seen one constructed quite that way. Can you explain how the structure works for me?
For your purposes you may use two inicode characters with codes 10004 and 10006. That's only one condition, one cell is equal to another or not, based on which you take one or another code.
Logical TRUE and FALSE in calculations are equivalent to 1 and 0 accordingly. Thus
10004+2*(A1<>B1) is equal to 10004+2*(FALSE) = 10004+2*0 = 10004
or
10004+2*(A1<>B1) is equal to 10004+2*(TRUE) = 10004+2*1 = 10006