Need formula to automatically calculate the incentive

Based on target and achievement, I need to count how much is the excess number of card of the achievement over the target.
The catch is, it should be counted on every level which is 0-10, 11-15, 16-20, 21 and above


Example 1:
if target is 6 and achievement is 18 then i need a formula for:
0-10 = 4 (7th-10th card)
11-15 = 5 (11th-15th card)
16-20 = 2 (16th-18th card)
21+ = 0


Example 2:
if target is 11 and achievement is 26 then i need a formula for:
0-10 = 0 (since target is 11, 0-10th card will not be counted)
11-15 = 5 (11th-15th card)
16-20 = 5
21+ = 6

One way, clean all expected results.

Try this in C8.

Please Login or Register  to view this content.

Hi windknife,

Really appreciate your help. but on my current level i wont be able to manipulate/change the data you have plotted.
I was looking for a more adoptive/simple formula separately on each cells.
like C8,D8,E8,F8 formulas and then kind of drag it down. please help if you still have a spare time.

How about this in C8?

Please Login or Register  to view this content.

copy down and across.

thanks, this solves the logic.

really hate to ask again but i cant even begin to solve the math problem on this,

followup: i need to count the number of excess cards after the achievement, it'll be easier just to show the excel table so without further ado, please find the attached and help me solve the problem (i know this is becoming more of a math logic help more than formula but im bad at both so...)