Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
formula w exception
can i have a formula that looks for one thing but with exceptions?
i.e. =IF(LEN(A5)3,1,"") but if A5 contains CMT, DIVS or FUND many thanks |
#2
|
|||
|
|||
=IF(OR(ISERROR(SEARCH("CMT",A5)),ISERROR(SEARCH("D IVS",A5)),ISERROR(SEARCH("FUND",A5)),
IF(LEN(A5)3,1,""), "" ) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Micayla Bergen" wrote in message ... can i have a formula that looks for one thing but with exceptions? i.e. =IF(LEN(A5)3,1,"") but if A5 contains CMT, DIVS or FUND many thanks |
#3
|
|||
|
|||
Thanks Bernard. however i get an error saying there is a missing parenthesis,
so i have added one to the end, then i get a formula message saying i am missing the value if true value if false values "Bernard Liengme" wrote: =IF(OR(ISERROR(SEARCH("CMT",A5)),ISERROR(SEARCH("D IVS",A5)),ISERROR(SEARCH("FUND",A5)), IF(LEN(A5)3,1,""), "" ) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Micayla Bergen" wrote in message ... can i have a formula that looks for one thing but with exceptions? i.e. =IF(LEN(A5)3,1,"") but if A5 contains CMT, DIVS or FUND many thanks |
#4
|
|||
|
|||
so i have tried this
=IF(OR(ISERROR(SEARCH("CMT",A6)),ISERROR(SEARCH("D IVS",A6)),ISERROR(SEARCH("FUND",A6))),,IF(LEN(A6) 3,1,"")) and still get nothing "Bernard Liengme" wrote: =IF(OR(ISERROR(SEARCH("CMT",A5)),ISERROR(SEARCH("D IVS",A5)),ISERROR(SEARCH("FUND",A5)), IF(LEN(A5)3,1,""), "" ) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Micayla Bergen" wrote in message ... can i have a formula that looks for one thing but with exceptions? i.e. =IF(LEN(A5)3,1,"") but if A5 contains CMT, DIVS or FUND many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |