Hi,

OK I'm struggling! I'm going from beginner to intermediate with EXCEL and have come across something I can't work out. Sorry if this has been posted before.

I have a cell that has a drop down in with 4 options - Quoted, In Progress, Invoiced & Paid. This sits within list of quotes etc for the month.

I have another cell which is working out if the month is after the current date then it is returing a true or false.

What I want to do and not sure if I am able to do this in one formula is as follows:

IF the result of the date validation is showing a True result (it is out of date) and the cell with 4 options is showing anything other than invoiced or paid then display text.

I tried this but it has failed :(
=IF(AND(A1=TRUE, B1="Quoted", B1="In Progress"),"Please Move To May","")

Any help would be much appreciated.

Cheers

Nick