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