Determine bonus point by the ranking

[vincentcheng]

In Japanese mahjong, one way to calcuate the bonus point, or call "uma" will be based on the player's net score. The way is following:
If one person's net score is greater than 0, then 1st player get +12, 2nd player -1, 3rd player -3, 4th player get -8
If two person's net score is greater than 0, then 1st player get +8, 2nd player +4, 3rd player -4, 4th player get -8
If third person's net score is greater than 0, then 1st player get +8, 2nd player +3, 3rd player -1, 4th player get -8

However, if player have same rank, their share the bonus point.

For example, two player of 4 player net score is >0, and they are both in 1st place, then they both get +6.
one more example, if only 1 of 4 player net score is >0 and the last 3 person have same score, then 1st player will get +12, and the last 3 person will get -4..

I don't know does it have easy way to achieve this or not...

 

[severynm]

Hi! I gave it a go and ended up with the following:

MrExcel.xlsm
	A	B	C	D	E	F	G	H	I	J
4		Person 1	Person 2	Person 3	Person 4
5	net score	2	2	-1	-1			1x >0	2x >0	3x >0
6	net rank	1	1	3	3		1	12	8	8
7	bonus	8	8	-4	-4		2	-1	4	3
8	final score	10	10	-5	-5		3	-3	-4	-1
9							4	-8	-8	-8
Sheet1

Cell Formulas
Range	Formula
B6:E6	B6	=RANK.EQ(B5,$B$5:$E$5)
B7:E7	B7	=SWITCH(COUNTIF($B$5:$E$5,">0"),1,INDEX($H$6:$H$9,B6),2,INDEX($I$6:$I$9,B6),3,INDEX($J$6:$J$9,B6))
B8:E8	B8	=B5+B7

However, the examples you gave do not make any sense when compared to the rules stated right above. It is unclear how the bonus point is "shared" if people have the same rank. Let me know if I am missing something.