Multiple answers

[agoodson1956]

I am trying to accomplish the following;

Cell C11 Change to 50%, 40%, 35% or 30% if cell C10 is 50,000, 100,000, 150,000, 200,000

 

[Michael M]

Use

=LOOKUP(C10,{50000,100000,150000,200000},{0.5,0.4,0.35,0.3})

format C11 as percent