| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AND OR SEARCH together
Im trying to use the below but not getting much joy.
=IF(AND(CW11=1,OR(SEARCH({"PRO","NOP","VAL"},$B11) ))),7,9) I would like to implement the condition that if CW =1 and B11 contains either PRO , NOP or VAL it returns the value 7. Can anyone help Thanks JAmie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Worksheet Functions | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Setting up and Configuration of Excel | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Links and Linking in Excel | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Threaded Mode
