Make tick appear

[Guest]

Is it possible to make a tick or cross symbol appear in a cell when certain
criteria are met?

e.g. If A1 equals B1 then tick appears in C1 or
If A1 does not equal B1 then a cross appears in C1

 

[Ken Johnson]

One way...

format the font in C1 to Webdings, then use the following formula in
C1...

=IF(OR(A1="",B1=""),"",IF(AND(A1=B1),"a","r"))

"a" in Webdings is a tick, while "r" is a cross.

The formula results in a blank when either A1 or B1 are blank.

Ken Johnson

 

[Ken Johnson]

Oops, I don't know why I put that other And in. Should have been...

=IF(OR(A1="",B1=""),"",IF(A1=B1,"a","r"))

Ken Johnson

 

[Guest]

Thanks, that worked but is it possible to use the other tick/cross symbols in
Wingdings?

Tick character code 252 / 00FC - Symbol (decimal / hex)
Cross character code 251 / 00FB - Symbol (decimal / hex)

 

[T. Valko]

Try this:

=IF(OR(A1="",B1=""),"",IF(A1=B1,CHAR(252),CHAR(251)))

Format the cell font to Wingdings

 

[Guest]

Excellent! Thanks very much Ken and T. Valko.

Try this:

=IF(OR(A1="",B1=""),"",IF(A1=B1,CHAR(252),CHAR(251)))

Format the cell font to Wingdings