| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statements using contains
I have a string of data in a cell and I want to say
If(a2 contains "admin","true,"false") I don't know how to say "contains" in this format, I may want to expand of the logic and say if(a2 contains "admin" and (contains "conversion"),1.25,false)) Cell a2 contains; plant one administrative assit(conversion) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| If statements | Excel Worksheet Functions | |||
| IF Statements | Excel Discussion (Misc queries) | |||
| IF statements | Excel Discussion (Misc queries) | |||
| IF statements | Excel Discussion (Misc queries) | |||
Threaded Mode
