Search for multiple substrings and return different values

Closed
jotied Posts 3 Registration date Wednesday September 9, 2015 Status Member Last seen September 9, 2015 - Sep 9, 2015 at 03:47 PM
I have a cell I2 which contains long string. I want to find out the following:
If string in I2 contains "month", then return "Monthly",
If string in I2 contains "year", then return "Yearly",
Else, return "other".

I am using the following formula, but I'm just getting #VALUE.
=IF(OR(ISNUMBER(SEARCH("month",I2)),"Monthly",(ISNUMBER(SEARCH(year,I2)))),"Yearly","Other")