I have a sheet that determines incentives. There's 2 criteria needed with multiple outcomes. Category A and category B.
If you score 10 over in category A and over in Category B you get rewarded at 110% of a value.
If you score over and both categories you achieve 100%
If you score below on either one category you get rewarded at 75%
If you score below on both you get rewarded 50%
If you score below by 5 points or more on either category you get 0%.
I need a formula to help with this please.
Bookmarks