=IF(A14%,"None",IF(A13%,40%,IF(A12%,60%,80%)))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Curtis" wrote in message
...
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