View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default 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.