IF OR LEN Formula Question

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
 
R

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

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top