| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula
=IF(OR(ISERROR(SEARCH("CMT",A4)),ISERROR(SEARCH("D IVS",A4)),ISERROR(SEARCH("FUND",A4))),"",
IF(LEN(A4)3,1,"")) i have this formula which should return a value of 1 if A5 contains more than 3 letters except if A5 contains CMT, DIVS or FUND what am i missing? many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
