Looking for a specific Excel function/formula

[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

 

[Trevor Shuttleworth]

Peter

=IF(D4<=30%,0,IF(D4<=35%,15%,IF(D4<=41%,25%,30%)))

Regards

Trevor