Expand an extra condition in formula

[Paula]

Hi

In a previous posting I was advised on the below formula, however I need to
expand it further to ask for the following conditions

If the length is 11 characters and the left 3 characters and right 3
charaters are the same say yes
If the length is 7 characters say yes.

I'm stuck on how to do this, can you help me adapt the below formula or
advise of what I could use?

Kind regards

Paula


=IF(AND(LEFT(F2,3)=RIGHT(F2,3),LEN(F2)=11),"yes","no")

 

[Bob Phillips]

Try

=IF(OR(AND(LEFT(F2,3)=RIGHT(F2,3),LEN(F2)=11),LEN(F2)=7),"yes","no")

HTH

Bob

 

[Mike H]

Paula,

Try this

=IF(OR(LEN(A1)=7,AND(LEN(A1)=11,LEFT(A1,3)=RIGHT(A1,3))),"Yes","")

Mike

 

[Mike H]

You never mentioned NO in your text but I see it in your first formula, Try
this instead

=IF(OR(LEN(F2)=7,AND(LEN(F2)=11,LEFT(F2,3)=RIGHT(F2,3))),"Yes","No")

Mike

 

[Paula]

Hi Mike,

Fantastic!! It works perfecrtly. Thanks again for your help, you have helped
me before.. I'll mark the post as helpful..

Bye and have a great day.

Paula

 

[Mike H]

Your welcome, glad i could help

Hi Mike,

Fantastic!! It works perfecrtly. Thanks again for your help, you have helped
me before.. I'll mark the post as helpful..

Bye and have a great day.

Paula