IF Statement

I'm creating a column with a formula field and am able to do the following:

if("column 1"='abc', 'Correct', "Not Correct").

In column 1 I have cells that contain the following:

abc
abc 76
xyz
qrs

I'd like to be able to write a formula that does the following:

If column 1 contains abc, then return 'correct' or if column 1 contains xyz then return 'maybe correct' or if column 1 contains qrs then return 'not correct'.

Basically I need the formula to
A. search for text rather than an exact match
B allow me to specify multiple search terms and provide a response to each term.
C. specify a value if neither of those conditions are met.

I can do this in excel with the following formula, but I need something that will work in Zoho reports:

=IF(ISNUMBER(SEARCH("abc",D2)),"Correct",IF(ISNUMBER(SEARCH("xyz",D2)),"Maybe Correct","Not Correct"))

Thanks in advance.

Jamie