Expand an extra condition in formula

  • Thread starter Thread starter Paula
  • Start date Start date
P

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")
 
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
 
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
 
Your welcome, glad i could help

Paula said:
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
Click to expand...
 
Back
Top