Displaying symbol from inside a calculation

[Guest]

Good morning. I need professional help.

I would like to display a symbol, rather than a alphameric character, as the
result of an IF statement.

Something like:

=IF(A1="Y", (box with X in it), (box with no X in it))

I've tried using CHAR inside the IF statement, but just get an alphameric
character. I think I specified CHAR(113) for the box with no X, and got a
'q'.

Any help would be appreciated. Thanks in advance.

 

[Peo Sjoblom]

If you format the cell with wingdings fonts you will get a square using char
113
if you want a check mark in a square use wingdings and char(252)

 

[RagDyeR]

Change the font of the cell containing your formula to "WingDings"!

Then ALSO ... Char(120) will display a box with an "X".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Good morning. I need professional help.

I would like to display a symbol, rather than a alphameric character, as the
result of an IF statement.

Something like:

=IF(A1="Y", (box with X in it), (box with no X in it))

I've tried using CHAR inside the IF statement, but just get an alphameric
character. I think I specified CHAR(113) for the box with no X, and got a
'q'.

Any help would be appreciated. Thanks in advance.

 

[Guest]

Thanks to you both!