Make tick appear
 

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

Make tick appear
 

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

Make tick appear
 

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

Make tick appear
 

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)



"Ken Johnson" wrote:

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

Make tick appear
 

Try this:

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

Format the cell font to Wingdings

--
Biff
Microsoft Excel MVP


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



"Ken Johnson" wrote:

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

Make tick appear
 

Excellent! Thanks very much Ken and T. Valko.

"T. Valko" wrote:

Try this:

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

Format the cell font to Wingdings

--
Biff
Microsoft Excel MVP


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



"Ken Johnson" wrote:

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