View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Expand an extra condition in formula

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(F 2,3))),"Yes","No")

Mike

"Paula" wrote:

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")