Multiple IF, AND conditions to return True/False

[avenkat]

Status	MAL	MQL	SAL	SQL	First associated date	Conditions True/False
Raw	10/25/2016	10/10/2016			10/10/2016
Pursuing	1/12/2017	4/18/2017 <tbody> </tbody>	4/18/2017		2/28/2018

<tbody>
</tbody>

So these being my columns, I need a To fill the last column with conditions that satisfy

1) IF (AND(MQL<=MAL,MQl=Firstassocaited date),OR(Status="Raw","Rejected","Unqualified"),TRUE,FALSE)
For some reason this formula return with a a FALSE for everything (see first data set where the conditions are met!)
2) IF(AND(SAL<=MQL,SAL<=Firstassocaited date, MQL>MAL,Status=Pursuing),TRUE,FALSE)

Not sure if this formula makes sense .
I need to know if the conditions satisfy via dates and status is reflecting the process is followed then true else false.


Thanks so much for any pointers

 

[avenkat]

Thank you ,
This works very well indeed.

You're welcome.

I must have had a brain freeze earlier, since I'm using INT in my formula, VALUE was Not needed, updated formula here:

	A	B	C	D	E	F	G	H	I
1	Contact Status	Member First Associated Date	Timestamp Lifecycle MAL	Timestamp Lifecycle MQL	Timestamp Lifecycle SAL	Timestamp Lifecycle SQL	Timestamp Lifecycle SAO	Timestamp Lifecycle SQO	MAL Stage
2	Rejected	10/10/2017 0:00	10/25/2017 10:56	10/10/2017 11:05					TRUE
3	Unqualified	11/14/2017 0:00	11/16/2017 7:24	11/14/2017 10:51	11/16/2017 7:24				TRUE
4	Pursuing	1/11/2018 0:00	1/11/2018 5:45	1/11/2018 5:45	1/11/2018 9:33				FALSE
5	Rejected	11/22/2017 0:00	11/27/2017 11:55	11/22/2017 16:33					TRUE

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet72​

Worksheet Formulas Cell Formula I2 =OR(AND(INT(D2)<=INT(C2),INT(D2)=INT(B2),OR(A2={"Rejected","Raw","Unqualified"})),AND(INT(E2)<=INT(D2),INT(D2)>INT(C2),INT(D2)=INT(B2),OR(A2={"Pursuing","Restored","New"}))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[jtakw]

You're welcome, glad it worked for you.