Need help for "if" in excel

[Chuck31]

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]

What are the rules? Is 95% 45 days late high, medium or low risk? What are the thresholds?

[Chuck31]

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]

=IF(AND(A2>=80%,B2>=11),"Low",IF(B2>=11,"High",IF(B2>=6,"Medium","Low")))

[Chuck31]

Thanks !