Nested IFs and various ranges changing other column cell

jmo

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?

Thanks.

Heather Duff

Hi @jmo ,

This won't be pretty, but try this:

=if(OR([Risk Reduction &/or Opportunity Enablement]@row=1,[Risk Reduction &/or Opportunity Enablement]@row=2,[Risk Reduction &/or Opportunity Enablement]@row=3,"Small",if(OR([Risk Reduction &/or Opportunity Enablement]@row=5,[Risk Reduction &/or Opportunity Enablement]@row=8,"Medium",if(OR([Risk Reduction &/or Opportunity Enablement]@row=13,[Risk Reduction &/or Opportunity Enablement]@row=20,"Large","")))

Let me know if it works!

Best,

Heather

jmo

@Heather D - when I copy/paste your formula I get the following:

#INCORRECT ARGUMENT SET

Heather Duff

@jmo My apologies - I'm missing some parenthesis. Let me know if the below formula works for you.

=if(OR([Risk Reduction &/or Opportunity Enablement]@row=1,[Risk Reduction &/or Opportunity Enablement]@row=2,[Risk Reduction &/or Opportunity Enablement]@row=3),"Small",if(OR([Risk Reduction &/or Opportunity Enablement]@row=5,[Risk Reduction &/or Opportunity Enablement]@row=8),"Medium",if(OR([Risk Reduction &/or Opportunity Enablement]@row=13,[Risk Reduction &/or Opportunity Enablement]@row=20),"Large","")))

jmo

That's the stuff, @Heather D !!!!

Thanks for your speedy reply!