Using If/And Function to figure out Eligibility of Benefit at a Future Date

Originally Posted by judgeh59

does this work for you?

=IF(AND(B2>240,C2<=TODAY()-90),"ELIGIBLE", "NOT ELIGIBLE")

Thank you! This one does work but when I entered in the formula it has the green box with the (!) saying it is an "inconsistent formula". However when I test it, it seems to work, so I am not sure what the error means?