combine 3 If AND statements

[subz-zero]

Hi

Can you help me in combining 3 statements below in to one line to i can put in one cell.

They work fine on each cell but need to combine.

Ive got one column with "high" "Medium" and "low" in there and one column with numbers in.

=IF(AND(D2 = "High,",I2 > 3),"FAILED High","PASS High"),
IF(AND(D2 = "Medium,",I2 > 10),"FAILED Medium","PASS Medium"),
IF(AND(D2 = "Low,",I2 > 20),"FAILED Low","PASS Low")

I want last column showing if the "High" passed or failed depending if the number criteria.

Hope this makes sense

Thanks in advance

 

[coheed1785]

What would the conditions be for the following:

PASS High
PASS Medium
PASS Low


?

 

[subz-zero]

What would the conditions be for the following:

PASS High
PASS Medium
PASS Low


?

Hi

If its High and more than 3 then its FAILED HIGH or else PASS HIGH
if its medium and more than 10 days then its FAILED MEDIUM or else PASS MEDIUM
if its low and more than 20 days then its FAILED LOW or else PASS LOW

Thanks again

 

[vds1]

Try,

=IF(I2>MID("High03Medium10Low20",SEARCH(D2,"High03Medium10Low20")+LEN(D2),2)*1,"FAILED " & D2,"PASS " & D2)

 

[coheed1785]

=IF(AND(D2="High,",I2>3),"FAILED High",IF(AND(D2="High,",I2<=3),"PASS High",IF(AND(D2="Medium,",I2>10),"FAILED Medium",IF(AND(D2="Medium,",I2<=10),"PASS Medium",IF(AND(D2="Low,",I2>20),"FAILED Low",IF(AND(D2="Low,",I2<=20),"PASS Low"))))))


I think this is what you want. Please let me know if this gives you the desired results.

 

[subz-zero]

Hi

The code below is return FALSE in every cell

=IF(AND(D2="High,",I2>3),"FAILED High",IF(AND(D2="High,",I2<=3),"PASS High",IF(AND(D2="Medium,",I2>10),"FAILED Medium",IF(AND(D2="Medium,",I2<=10),"PASS Medium",IF(AND(D2="Low,",I2>20),"FAILED Low",IF(AND(D2="Low,",I2<=20),"PASS Low"))))))


I think this is what you want. Please let me know if this gives you the desired results.

 

[coheed1785]

It worked on my sheet when I put a number in I2, and High, Medium, or Low, in D2.

I did notice that your formula is looking for "High," in D2, are you sure it should be looking for the comma?

Could you possibly copy what you currently have in I2 and D2 so I can compare?

 

[subz-zero]

Hi

This seems to work

Many Thanks for your help

Simple but effective.

Try,

=IF(I2>MID("High03Medium10Low20",SEARCH(D2,"High03Medium10Low20")+LEN(D2),2)*1,"FAILED " & D2,"PASS " & D2)

 

[subz-zero]

Hi

It shouldnt contain commas, sorry about that, ive taken them out and it seems to work

Many thanks for your help quys and quick responses.

 

[coheed1785]

Whatever you did here vds1, it's genius!