I know that "ticks" work well with formulas such as:

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

Can the formula to adjust to accomodate text as well? I wasn't sure! I tried
it, but it only seemed to register numerical values.

Dan