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.

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

it should work with text as long as ther text is truely alike.

"Dan the Man" wrote:

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

Will work just as well with text as with numbers.

Remember to format as Webdings.


Gord Dibben MS Excel MVP

On Fri, 6 Jul 2007 11:46:04 -0700, Dan the Man
wrote:

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