| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find text in a string formula
Here is the formula I am using. The numeric if's work but the text one does
not. Cell AA7 contains a text statement and in that statement the term secure or security might appear. If if does I want to return an "X". If it does not I want to continue to evaluate the other cells. IF(AA7<"secur",IF(AND(E7<"",F7<"",G7<"",I7<"" ,P7<""),IF(AND(Q7<"",S7<"",V7<"",Q7<"",AB7<" "),"P","X"),"X"),"P") Thanks Todd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel -find records which DO NOT contain a particular text string | Excel Discussion (Misc queries) | |||
| Looking up a string of text within a string of text | Excel Worksheet Functions | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
