| Home |
| Search |
| Today's Posts |
|
#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") |
| 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 | |||
Threaded Mode
