NESTED IF FUNCTION TO DETERMINE COMPLEXITY OF A PROJECT

Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010




Hi
Thank you for speaking with me this evening. I appreciate your willingness to help. As discussed, I am looking for help with the nested IF function.
Attached spreadsheet has the values and the formula. For few conditions, the results are as expected but for a few other conditions, they are not as expected.
Could you please review and suggest what could be wrong or if there is a better alternative to the formula I used here?
Thanks & Regards
Mohan Naidu

Image of solution by the user:

nested if function

Criterion
Tier-1: >10,000 hours, impacts multiple divisions or multiple departments and/or greater than 9 teams. (Any 2 of these 3 conditions should be met)

Tier 2 - 4,000 - 10,000 hours, impacts multiple departments and/or 6 to 9teams. (Any 2 of these 3 conditions should be met)

Tier 3: 120 - 4,000 hours

Watch the training video to learn about the solution. Also note the interesting use of comments.






Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010