Originally Posted by joeu2004[_2_]

"D4WNO" wrote:
I wish to work out something similar to this:
if Column A = Success AND B = Success AND C=Success
then Make column D say "<25 Days"
if Column A = Failure AND B=Success AND C = Success
then make column D say "<35 Days"
if Column A - Failure AND B = Failure AND C = Success
then make column D say "<45 Days"
[....]
By themselves each line will say something like this
but don't know how to tag all 3 together:
=IF(AND(AP2="Failure",AQ2="Failure",AR2="Success") ,
"25 Days Plus","Open")

First you say the data are in columns A, B and C. But based on your
example, they are in columns AP, AQ and AR.

First you say you want the results to be "<25 Days", "<35 Days" and "<45
Days". But the results in your example are "25 Days Plus" or "Open" --
incomplete, but obviously very different.

Finally, you give no indication of what you want when none of those 3
conditions is met. Maybe "Open"?

So I don't really know what you need. If the following does not do what you
require, please clarify your requirements.

=IF(AND(AQ2="Success",AR2="Success"),
IF(AP2="Success","<25 Days","<35 Days"),
IF(AND(AP2="Failure",AQ2="Failure",AR2="Success"), "<45 Days","Open"))

Caveat: The middle IF expression assumes that AP2 is either "Success" or
"Failure". If it might something else (e.g. empty) and you want to treat
that as "Open", then write:

=IF(AND(AQ2="Success",AR2="Success"),
IF(AP2="Success","<25 Days",IF(AP2="Failure","<35 Days","Open")),
IF(AND(AP2="Failure",AQ2="Failure",AR2="Success"), "<45 Days","Open"))