=IF(AND(AND(A2="Open",OR(AB2="CMRA",AB2="MRC-PARTS")),D28),"yes","no")

Not sure if this is what you need. If not post back with clearer detail on
the criteria you want to test.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


" wrote:

I am trying to create an if statement that has several different
factors. Here is what I am trying to do: If A2(status) = Open and
AB2(Category) = CMRA or MRC-PARTS and the D2 (date created) is greater
then 8 days then populate "yes", however if it does not reach this
criteria then populate "no".

Is this even possible?

Please advise,