This guide would help you to find out whether a cell contains specific text. This can be extended to multiple cells and give you flexibility on your calc operation.
This guide explains how you can check for multiple conditions in Calc using IFS function. Generic Formula =IFS(test1, result1, [test2, result2],...) test1: First logical test result1: result when test1 is true. test2, result2 [optional] – second test value pair. Explanation of IFS