I am trying to create an If Then statement to use in an excel spreadsheet using data from 2 or 3 columns.
Column AB has text. Column AA has a date in it. I need the statement to say if column AB says RFEP or TRFE and Column AA is greater than 08/01/07, the true value is "Y" and the false value is "N".
=IF((AA2>08/01/07)+(AB2="RFEP"),"Yes","No") This is only picking up the date in AA2. I tried the & for a connector and got “value” only.
As you can see, I haven't even tried to add the TRFE information.

I would also like to add column X to the mix. If column X has a "Y" in it, it would also be included in the true value of "Y". However, I would be very happy with just the first two items.
Thank you for the help.