Insert a tick mark in an IF statement result

Insert a tick mark in an IF statement result

Didn't find your answer?

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.

By Steve Kesby
19th May 2014 15:54

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. 

Thanks (0)
avatar
By ALAN.GOLDSMITH
19th May 2014 15:55

insert tick mark

Hi

You need to set the font to Wingdings - it should then show up as a tick mark

Alan

 

Thanks (0)
Replying to raycad:
avatar
By User deleted
19th May 2014 16:50

Marlett

ALAN.GOLDSMITH wrote:

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

Thanks (0)