IF OR LEN Formula Question

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

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