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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
What would the formula be for the cell? 3
IF formula with 3 possible outcomes 8
How to display result of 3 possible outcomes 3
Formula Help 1
if function, how? 4
Scrabble Value calculation for Welsh words 0
Need Help with Excel and Flagging Outcomes! 4

Back
Top