Ticks!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

Ticks? I assume you mean "quote marks". Also, I assume you mean text in
place of the two quote marks next to each other. Those two quote marks next
to each other define a text constant with no text (an empty string)... if
you want to test for text, put the text between the quote marks.

Rick
 
Will work just as well with text as with numbers.

Remember to format as Webdings.


Gord Dibben MS Excel MVP
 
Back
Top