Solved: 2 formulas required - Part 2

[Hoopsah]

Hi again,

I have a spreadsheet where I have to work out how many days have passed and has a target been met.

Process 1 - 2 days internal, 5 days internal assett, 10 days External
Process 2 - 2 days internal, 5 days internal assett, 10 days External
Process 3 - 2 days internal, 5 days internal assett, 20 days External
Process 4 - 2 days internal, 5 days internal assett, 20 days External
Process 5 - 2 days internal, 5 days internal assett, 10 days External
Process 14 - 2 days internal, 5 days internal assett, 10 days External

I will have 3 boxes showing the results - Internal, Internal Assett & External. Depending on which process the user inputs I would like a formula which would ask:

If cell = process 1 then if cell <= 2, "Yes", "No"
if cell = process 2 then if cell <=2, "Yes", "No"

and so on.

Cheers

Hoopsah

[Bob Phillips]

I know this is wrong, but you are not clear, so maybe this can point

=IF(AND(OR(cell="Process 1",cell="Process 2",...), cel2<=2),"Yes","No")

[Hoopsah]

Hi XLD,

Thanks for that, I amended the formula to read the correct cell details and it works a treat.

Cheers again

Hoopsah

[Hoopsah]

Hi XLD,

sorry about this - I know I marked this solved, but,

I have the formula now reading :

=IF(AND(OR($E$2="Process 1",$E$2="Process 2",$E$2="Process 5",$E$2="Process 14"), $I$2<=10),"Yes","No")


Do you know how I can insert into that the option for Process 3 <= 20 and Process 4 <= 20

??

[Bob Phillips]

=IF(OR(AND(OR($E$2="Process 1",$E$2="Process 2",$E$2="Process 5",$E$2="Process 14"), $I$2<=10),
AND(OR($E$2="Process 3",$E$2="Process 4"),$I$2<=20)),"Yes","No")

[Hoopsah]

Ahh Fantastic,

thanks for your help on this Bob (XLD)

Cheers

Hoopsah (Gerry)

[Shazam]

=IF(OR(AND(OR($E$2={"Process 1","Process 2","Process 5","Process 14"}), $I$2<=10),AND(OR($E$2={"Process 3","Process 4"}),$I$2<=20)),"Yes","No")

[Hoopsah]

Cool,

cheers Shazam - Curly Brackets make it look a bit tidier.