| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with solving this if statement which uses a search for text s
Hi
I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| Fun with text functions - search for text | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| If then statement to search for text possible? | Excel Discussion (Misc queries) | |||
| Search for a specific character in a cell in an if statement | Excel Worksheet Functions | |||
Threaded Mode
