Hi,

=NOT(ISERROR(SEARCH("Admin",A2)))

and this

IF(NOT(ISERROR(AND(SEARCH("Admin",A2),SEARCH("Conv ersion",A2)))),1.25,"False")

Mike

Mike

"Merge" wrote:

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)