The following example is a listing of the number of people that placed in the top 6 positions. There is a tie for 3rd with 3 people. I need a formula in column "C" that will distribute 3rd, 4th & 5th place prizes equally among the 3 people. (Assume column "D" has the prizes for 1st place thru 6th place)
Note: the final desired result in column "C" is:
1st place = D2 = $100
2nd place = D3 + $50
3rd place = D4+D5+D6 divided by B4 = $13.33
4th place = 0 = $0
5th place = 0 = $0
6th place = D7 = $2

A B C D
1 Place #People Prize Prize List
2 1 1 $100
3 2 1 $50
4 3 3 $25
5 4 0 $10
6 5 0 $5
7 6 1 $2

Note that the value in column "B"has been calculated using the "Rank" function. Thanks in advance for your help!