I'd like to check whether a string of text in a cell contains either "something" or "somethingelse".
IF(ISNUMBER(FIND($F$5,D8)),$F$4,0) OR IF(ISNUMBER(FIND($F$6,D8)),$F$4,0)
The result should either output the contents of cell F4 if True or 0 otherwise.
I've tried a few nestings with no luck...