I need to have a formula that looks at cell a1 and produces the following in
cell b1

if a1 4% outcome needs to equal 'None"
if a1 <=4% but greater than 3% the outcome needs to equal 40%
if a1 <=3% but greater than 2% the outcome needs to equal 60%
if a1 <=2% outcome needs to equal 80%

thanks