I need to perform a different calculation based on the text "AB" being contained in a cell.
Simplified example: If "Cat" is in A1 then the formula in D1 would be =B1*C1
If A1 contains "AB" nested in a word the formula used would be =(B1/C1)*3.
I've seen how to do this if the AB was always in the same position but in this case the text string could be "Crab" or "Absolute" or "Alabama".
Is this even possible without using lookup and listing all possible words?
Thanks
Bookmarks