calulating multiple % rates

[Whymama]

ok here is what I need help with , a formula for:

if F is less than 75% then G needs to be $0
If F is between 75 and 85% then G needs to be $15
If F is between 85 and 99% then G needs to be $30
If F is 100% or greater then G need to be $100

So I've done single percents =IF(E7>F7,100,0) Basically they sell 100 percent of goal (E being sales , F being sales goal) get $100 bonus , so G would be $100 bonus they earned
But have never done one that has different bonus levels like this.

[tuph]

It's easier to give you a quick answer if you attach a copy of your worksheet. Click on <Go Advanced> button to see the attachment options. Remember to remove or replace any sensitive data before uploading.

[Russell Dawson]

Try this

Please Login or Register  to view this content.

[Whymama]

Thank you for trying but that did not work. I know its harder with out the file to play in.

[Whymama]

I believe I've attached the file so you can look at it. Thanks for the help

[Russell Dawson]

That's better

I've done it as best I can but you may need to adjust/reverse Event Sales and Bonus Target. First weekend is completed and works. I've adjusted formula to allow for blanks.