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

Hi Nick,

You're missing an OR in there. You want to say A1 = TRUE AND B1 = either Quoted OR In Progress..

=IF(AND(A1=TRUE,OR(B1="Quoted",B1="In Progress")),"Please Move To May","")

Hi Nick,

Am Thu, 5 Apr 2012 16:02:34 +0000 schrieb Nick_GB:

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.

try:
=IF(AND(OR(B1="Quoted",B1="In Progress"),A1=TRUE),"Please Move To May","")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thank you both!