Displaying symbol from inside a calculation
 

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.

Displaying symbol from inside a calculation
 

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)


--
Regards,

Peo Sjoblom


"pdberger" wrote in message
...
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.

Displaying symbol from inside a calculation
 

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!
================================================== ===


"pdberger" wrote in message
...
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.

Displaying symbol from inside a calculation
 

Thanks to you both!

"RagDyeR" wrote:

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!
================================================== ===


"pdberger" wrote in message
...
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.