Nested if help

  • Thread starter Thread starter Curtis
  • Start date Start date
C

Curtis

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
 
=IF(A1>4%,"None",IF(A1>3%,40%,IF(A1>2%,60%,80%)))

--
HTH

Bob

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