Hello

I have a spreadsheet where I would like to create a formula that says:

If cell.Offset(0, -2) contains "with GST", then formula = "cell.Offset(0,
-1)/8".
Elseif cell.Offset(0, -2) contains "without GST", then formula = "0"
Elseif cell.Offset(0, -2) contains "ZR", then formula = "0"

I'm not sure how to write the formula to look for something *contained* in
the target cell, rather than checking the entire cell contents. Any help
would be greatly appreciated.

Thanks
MMH