How can I use two different inputs to determine a specific result in one cell?
Hi there - I'm not sure what is the best formula to use & appreciate any help! I have a 9 different scenarios that can return 4 different results. This is something like a matrix translated into the possible combinations.
The matrix / combinations are in a separate sheet but can also be built into the formula directly, if that is easier.
Importance: 1; Feasibility: 2; result = Rejected
Importance: 2; Feasibility: 1; result = Backlog
Importance: 3; Feasibility: 1; result = Priority
... and so on for a total of 9.
I need to consider what is returned in the Importance and Feasibility columns, not just the total sum. I tried playing around with IF, AND, OR statements -- but it feels clunky. Any other suggestions?
Help Article Resources
Check out the Formula Handbook template!