NESTED IF FUNCTION IN EXCEL TO DETERMINE COMPLEXITY OF A PROJECT
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
Image of solution by the user:
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.