Insert a symbol in an IF function - Excel

Actually, this is how I do it:
I insert a special character into a cell, copy it and put it in quotes in my formula which gives a letter, but it doesn't matter then I set the column to the correct font and everything works.

=IF(B1=AA1,"s","") the s is actually a symbol from the symbol font that takes its form with the column in the correct font

Let me know if that works for you?
--
What is learned with effort is not easily forgotten; What is learned and acquired easily is forgotten and fades quickly!

So actually, no, putting it in quotes doesn't change anything in my cell. And if I put the quotes in the cell where I inserted the symbol, it gives me 2 squares.

I then tried putting an apostrophe (which should turn the cell into text), and it showed me a circle with a cross inside it (so a symbol)...

So I have my temporary solution: I need to set the cell containing the formula to a font of CommercialPi BT (symbol font), but then my "value if false" (which was the text "Problem" with conditional formatting highlighting the problem cells and turning them red) won’t make any sense... So I will use 2 columns (one with value if true in CommercialPi BT font, and another with the value if false in normal font. But this manipulation (just a font) seems unreliable and a bit shaky for the long term of my file, so I’m open to any other ideas you might have.

Thanks :)

Hello,

Except that I can't insert a symbol while typing the formula and copying my symbol results in a "")" in the formula, so instead of a check box, I have a parenthesis...
It doesn't matter, the main thing is to remember to place the character between "")" and that the font of the cell is correct, as Ange mentioned.
Now, your problem might be changing the font if your cell also needs to receive text, which can only be done in VBA, and differently if the text mixes fonts or not.

Eric

Hi,

I just saw this discussion; I might have a solution. With the known data, if B1 and AA1 have the same value, we display a checked box (regardless of shape or color).
Not knowing where the formula should be placed in the example, I used cell E4 for one possibility and E10 for another example.

Using this formula each time:
=IF(B1=AA1,"checked box","false value")

https://www.cjoint.com/?0cdnVoXNaRw

--
Cheers,
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Hello,
I suggest this, then it's up to you to see if your formula needs to be adjusted later with text for the true value or the false value, it works, no special font needed for the column
=IF(A1=B1; "blue checked box";"red unchecked box")
See attached file.
https://www.cjoint.com/c/2cdr8LM5VDR
Let me know if that works for you?
What is learned with effort is not easily forgotten; What is learned and acquired easily is forgotten and fades quickly!