I am trying to create a formula that tells me "Eligible" or "Not Eligible" based on two facts:
1) # of hours worked (i.e. 240 hours)
2) Employed for 90 days from hire date

In my spreadsheet, I have a total number of hours worked in a column, and the hire date in another column. I just found out the current formula I use isn't quite working (this is a formula I gathered from Googling).
Here is the current formula: =IF(AND(B2>240)*AND(MONTH(C2)>3),"ELIGIBLE", "NOT ELIGIBLE")

I have no idea how I got that formula as it was months ago that I entered it in my spreadsheet.

Can anyone help, please?