Can't workout or if and formula

[Groovicles]

Hi everyone,

I have two cells, A1 and B1

What I'm trying to do is create a formula which will return the result TRUE if both cells A1 and B1 have text in them OR if both cells A1 and B1 do not have text. Therefore, if either one of the cells have text but the other one doesn't, the result is FALSE.

Any ideas?

Thanks!

[Glenn Kennedy]

It depends on what you mean by text...

=IF(OR(ISNUMBER(A1),ISNUMBER(B1),ISBLANK(A1),ISBLANK(B1)),FALSE,TRUE)

If $ and * and " count as text, this works....

[Groovicles]

Hi Glenn,

Thanks for your suggestion. I'm afraid the result is not correct when I try it in excel. Both A1 and B1 have a 1 in it but the result is False where as it should be true.

So again, if A1 and A2 have text (of any kind), or if A1 and A2 have nothing in them, the result should be True. Anything else is False.

[Glenn Kennedy]

That's not the same question, is it??

[Groovicles]

Hey Glenn, yes its the same question. If A1 and A2 both have text, or if A1 and A2 both do not have text, the result is True, otherwise its False.

[Glenn Kennedy]

Try this, then:

=OR(AND(ISBLANK(A1),ISBLANK(B1)),AND(LEN(A1)<>0,LEN(B1)<>0))

[Glenn Kennedy]

Hey Glenn, yes its the same question. If A1 and A2 both have text, or if A1 and A2 both do not have text, the result is True, otherwise its False.

Noo.. I'd interpret "TEXT" as meaning something other than a number....

[Groovicles]

That's perfect, thanks Glenn. Sorry about the text misunderstanding.

[Glenn Kennedy]

WooHoo! Glad to have helped and thanks for the Rep.