insert a symbol in an IF function - Excel

Question

Hello,

I want to insert a symbol (specifically, a checked box, code 41 in the symbols of the "CommercialPi BT" font) such as:

=IF(B1=AA1;checked box;"value if false")...

However, I can't insert a symbol while typing the formula and copying my symbol results in ")" in the formula, so instead of a checked box, I have a parenthesis...

Do you know how to do this? I heard that every symbol has its code, but I suppose the code I see in my symbols (41, which is a number) is not the one I need...

Thank you very much

Rrrady

Raymond PENTIER · Accepted Answer

Hello.  Try putting your "checked box" in cell Z1 and writing your formula =IF(B1=AA1,Z1,"false value") -- It’s nice to be retired! Especially in the Caribbean ... :-) &#9787; Raymond &#9794;

Ange420 · Answer

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!

Rrradassse · Answer

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 :)

eriiic · Answer

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

Mike-31 · Answer

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.

Ange420 · Answer

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!

Insert a symbol in an IF function - Excel

6 answers

Reinstallation of w11 impossible after pc crash...

Tencent impossible to remove

Is there enough storage space on my vps?

Car gps tracker

Transfer mp3 from pc to mobile

Unrefreshed usb drive on android interface

Erreur de captcha

How to delete quarantine files in defender?

Issue with accents

Https://www.youtube.com/@topblazo