Looking for a specific Excel function/formula

  • Thread starter Thread starter petern
  • Start date Start date
P

petern

Hello-I am looking for the function/formula that will give me th
following data:
Cell D4 has a numerical figure-it is a percent

I want cell D6 to show the following:
If Cell D4 is 30% or less, then D6 shows 0
If Cell D4 is >=31% but <=35%, D6 must show 15% (or .15)
If Cell D4 is >=36% but <=41%, D6 must show 25% (or.25)
If Cell D4 is =>42%, D6 shows 3% (or .30)

Thank You
Pete
 
Back
Top