Hoopsah
06-25-2008, 12:39 AM
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
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