PDA

View Full Version : Need help for "if" in excel



Chuck31
10-06-2008, 09:45 AM
Hi all,

I need to be able to do the following:

Based on a percentage of completion and # of days late to be able to determine if a task is at a high, medium or low risk
Ex:

Completion Days late Risk
95 45
0 10
50 20

Thanks,

C.

Bob Phillips
10-06-2008, 09:55 AM
What are the rules? Is 95% 45 days late high, medium or low risk? What are the thresholds?

Chuck31
10-06-2008, 10:05 AM
If % is >= 80 and #days >=11 (Low)
% >=50<80 # days >=11 (High)
% >=50<80 # days >6<11 (Medium)
% >=50<80 # days < 6 (Low)
% <50 and # days >=11 (High)
% <50 and # days >6<11 (Medium)
% <50 and # days < 6 (Low)

Bob Phillips
10-06-2008, 10:39 AM
=IF(AND(A2>=80%,B2>=11),"Low",IF(B2>=11,"High",IF(B2>=6,"Medium","Low")))

Chuck31
10-06-2008, 10:46 AM
Thanks !