Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code advice please...
I have the following in a cell currently.
=IF(OR(ISNUMBER(SEARCH({"live","appoint"},J2&N2&R2 ))),"T","F") I am looking for the works live or appointment in on of 3 cells. I need to look for more words. Would it be best at that point to use a user defined function or is there a way to modify the above for more than 2 options? Which would be the fastest? I know I could do a function that would test for several varible using if elseif else, but I am not sure which would be fastest, or how to modify the above to test for three or four conditions. Thanks Bruce |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code advice please...
=IF(OR(ISNUMBER(SEARCH({"live","appoint","tom","di ck","harry"},J2&N2&R2))),"
T","F") as an example. Just add your words to the list. -- Regards, Tom Ogilvy "BruceJ" wrote in message news:AOPsb.193292$Fm2.178384@attbi_s04... I have the following in a cell currently. =IF(OR(ISNUMBER(SEARCH({"live","appoint"},J2&N2&R2 ))),"T","F") I am looking for the works live or appointment in on of 3 cells. I need to look for more words. Would it be best at that point to use a user defined function or is there a way to modify the above for more than 2 options? Which would be the fastest? I know I could do a function that would test for several varible using if elseif else, but I am not sure which would be fastest, or how to modify the above to test for three or four conditions. Thanks Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
any advice pls.. | Excel Discussion (Misc queries) | |||
pls advice | Excel Worksheet Functions | |||
Little more advice on this code | Excel Discussion (Misc queries) | |||
Almost got it !! but need advice | Excel Worksheet Functions | |||
Need advice and code help with working with *.dbf files in Excel 97 | Excel Programming |