This is a formula written for Google Sheets. It looks for text matching one of three conditions and otherwise will display ‘Not Detected’.