IF OR LEN Formula Question

[Paula]

Hi, Can you help me with a formula, I need to identify all instances where a
cell contains an entry with either 7 or 11 characters. so for example the
following would be recognised as yes, anything not 7 or 11 characters would
be no. Hope you can help.

LON-NYC
LON-NYC-LON

Many thanks
Paula

 

[Ron@Buy]

Without knowing the layout of your worksheet it's difficult to give a
definitive formula but try working with this:
=IF(OR(LEN(A1)=7,LEN(A1)=11),"yes","no")

 

[eksh]

let say LON-NYC on cell A1, you may set formula in A2
=IF(LEN(A1),"Yes","No")

 

[Mike H]

Paula,

If youe happy with TRUE/False use this

=OR(LEN(A1)=7,LEN(A1)=11)

If it needs to be YES/NO, use this

=IF(OR(LEN(A1)=7,LEN(A1)=11),"Yes","No")

Drag down as required.

Mike

 

[Jarek Kujawa]

=IF(OR(LEN(A1)=7,LEN(A1)=11),"yes","no")

 

[RagDyeR]

Another configuration:

=IF(OR(LEN(A1)={7,11}),"Yes","No")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hi, Can you help me with a formula, I need to identify all instances where a
cell contains an entry with either 7 or 11 characters. so for example the
following would be recognised as yes, anything not 7 or 11 characters would
be no. Hope you can help.

LON-NYC
LON-NYC-LON

Many thanks
Paula