How to calculate multiple conditions?

[D4WNO]

Hi everyone,

This is a fairly new concept to me so I hope you can help. I have
columns of data, a sample is below and I wish to work out somethin
similar to this:

if Column A = Success AND B = Success AND C=Success then Make column
say "<25 Days"
if Column A = Failure AND B=Success AND C = Success then make column
say "<35 Days"
if Column A - Failure AND B = Failure AND C = Success then make column
say "<45 Days"

Each of the results in columns A to C are calculated from IF statement
from a field further up in my spreadsheet, I'm just trying to work ou
the time between 2 days and bunch them together into 3 groups. Do yo
also think there might be an easier way to work out columns A,B and C i
the first place? My only concern and why I feel the date to do soMEthin
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
sections (if column A, B and C all say Success)

By themselves each line will say something like this but don't know ho
to tag all 3 together:
=IF(AND(AP2="Failure",AQ2="Failure",AR2="Success"),"25 Day
Plus","Open")


Not Planned but Resolved within 25 Days / Not Planned but Resolve
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 Failur

 

[zvkmpw]

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"


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

Rather than use a logical expression with individual cells, you could concatenate the three:
AP2 & AQ2 & AR2
Then you could use VLOOKUP(AP2 & AQ2 & AR2, ... ) to choose the result from a table. There are only 8 possibilities.

 

[joeu2004]

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

 

[D4WNO]

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

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

Thank you so much for your help :