Hi everyone,

This is a fairly new concept to me so I hope you can help. I have 3 columns of data, a sample is below and 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"

Each of the results in columns A to C are calculated from IF statements from a field further up in my spreadsheet, I'm just trying to work out the time between 2 days and bunch them together into 3 groups. Do you also think there might be an easier way to work out columns A,B and C in the first place? My only concern and why I feel the date to do soMEthing similar to the above is because if I just say if A = Success or if B = Success then potentially the same line could appear in each of the 3 sections (if column A, B and C all say Success)

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")


Not Planned but Resolved within 25 Days / Not Planned but Resolved within 35 Days / Not Planned but Resolved within 45 Days
Failure Failure Failure
Failure Failure Failure
Success Success Success
Success Success Success
Failure Success Success
Success Success Success
Failure Failure Failure
Success Success Success
Failure Failure Success
Success Success Success
Failure Failure Failure