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