Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand an extra condition in formula
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") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand an extra condition in formula
=IF(OR(LEN(F2)=7,AND(LEFT(F2,3)=RIGHT(F2,3),LEN(F2 )=11)),"yes","no")
-- David Biddulph 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") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand an extra condition in formula
Try
=IF(OR(AND(LEFT(F2,3)=RIGHT(F2,3),LEN(F2)=11),LEN( F2)=7),"yes","no") HTH Bob "Paula" wrote in message ... 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") |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand an extra condition in formula
Paula,
Try this =IF(OR(LEN(A1)=7,AND(LEN(A1)=11,LEFT(A1,3)=RIGHT(A 1,3))),"Yes","") 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") |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand an extra condition in formula
Hi Mike,
Fantastic!! It works perfecrtly. Thanks again for your help, you have helped me before.. I'll mark the post as helpful.. Bye and have a great day. Paula "Mike H" wrote: 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") |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand an extra condition in formula
Your welcome, glad i could help
"Paula" wrote: Hi Mike, Fantastic!! It works perfecrtly. Thanks again for your help, you have helped me before.. I'll mark the post as helpful.. Bye and have a great day. Paula "Mike H" wrote: 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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify and add extra condition | Excel Worksheet Functions | |||
How to expand Index/Match formula | Excel Worksheet Functions | |||
How to expand the formula bar when excel opens | Excel Discussion (Misc queries) | |||
How do I set a cell to auto expand when it has a formula? | Excel Worksheet Functions | |||
Need help to expand existing formula | Excel Worksheet Functions |