I wish to insert tick and cross mark in a result of an IF statement. e.g. =IF(A1=20,"agrees "&CHAR(252),"disagrees "&CHAR(251))
I have tried using =CHAR(252) where I desire the tick mark to appears, but it gives a result of u with two dots above it (Sorry - I am sure there is a name for this character). Ditto problem with =CHAR(251).
I have seen answers elsewhere and believe I am writing the correct formula. So I assume it is something in my format or set up?
Any suggestion to fix or get around this is greatly appreciated.
Thanks
Replies (3)
Please login or register to join the discussion.
You need to use the wingdings font...
... for the tick and cross to work.
The problem is with the extra text that you're using it will come out as:
You'll need to put the text and the / or X in separate cells.
insert tick mark
Hi
You need to set the font to Wingdings - it should then show up as a tick mark
Alan
Marlett
You need to set the font to Wingdings - it should then show up as a tick mark
If the font is set to Marlett instead, then the [Lower Case] letters a and b can be used for the tick and the [Lower Case] letter r can be used for the cross
The formula should be amended to
=IF(A1=20,"a","r")
With the column header reading something along the lines of - "Agrees?"
The problem is, as Steve has mentioned, that there is no way to make it show as a tick and still retain the other text