Bonus Calculation

Thanks for the formula and taking the time to respond. The problem I see is that it is only looking at two scenarious, B5 and B6, but overlooks B7. I think part of that problem is how they worded this. Also, won't you need a starting point, from which point someone would begin to be entitled to a bonus? If revenues were $3,432,000, that person would still be entitled to a bonus, albeit a very small percentage. I changed my spreadsheet to reflect this, which to me makes more sense, as there is now a starting point. When I use the original formula, I get a 76.89% payout. When I do it manually I get a 72% payout (the manual part is probably wrong too). May be now it will make more sense to someone. I have reworded some of it also, they aren't really targets or goals, just if you hit this income level, you get this %, etc. The one weird thing I noticed in the formula is that if B9<B7, and also B9<B8. Both are true, so which one is acted upon? Hopefully this revised spreadsheet will make it more clear.