I know its simple but I can't get it to work right.

=IF(ISNUMBER(SEARCH(OR("bill","Credit"),[@Descriptn])),"BillBack",[@[Our Ref Trim]])

If the Descriptn has "bill" or "Credit" anywhere with the text string, I want to return "BillBack", if not, return the value of "Our Ref Trim"

So, I entered the formula above but it is not catching descriptions that contain "billback", "bill ", "credit"

Please help.

PS. "Our Ref Trim" is the helper column I use to =Trim() the "Our Ref" column. I'd like to get rid of the "Our Ref Trim" column and just add the "Trim" function within the formula above.

Thanks!