Nested IFs and various ranges changing other column cell
Hi team - I have a column called Risk Reduction &/or Opportunity Enablement that has specific numbers in a drop down [1, 2, 3, 5, 8, 13, or 20].
Second column is called Risk Reduction &/or Opportunity Enablement Size and has Small, Medium, Large as drop down options.
What I need is if the Risk Reduction &/or Opportunity Enablement selection is 1, 2 or 3 then Small in the second column; if 5 or 8 then Medium and if 13 or 20 then Large.
Any best practices to make that happen?
Help Article Resources
Check out the Formula Handbook template!