If, And Or

[Nick_GB]

Hi,

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

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

I have another cell which is working out if the month is after th
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 i
as follows:

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

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

Any help would be much appreciated.

Cheers

Nic

 

[Claus Busch]

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

 

[Nick_GB]

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 T
May","")*

Thank you both