gordonrobb
New member
- Joined
- Aug 6, 2019
- Messages
- 6
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 365
I'm putting together a spread sheet to keep track of the scores for Mah Jong and I'm stuck at a bit. Basically there are 4 players, and the one who goes Mah Jong get's a score that the other 3 pay them. If that person is East wind, everyone pays them double. Other wise the person who is east wind pays double. I've managed to figure all of that out. It's not elegant but it works.
However, once the Mah Jong winner has been paid, the other 3 players pay each other the difference between their scores. So if the scores were 25, 50, 20, 5 and the first player was East Wind. If the second player (50) went Mah Jong, everyone pays that player. Then plare one would receive 5 from player 3 (25-20) and 20 from player 4 (25-5). But also, player 3 would receive 15 from player 4 (20-5). Can anyone help me with a way of figuring this out? It has to ignore who went Mah Jong out of the 4.
However, once the Mah Jong winner has been paid, the other 3 players pay each other the difference between their scores. So if the scores were 25, 50, 20, 5 and the first player was East Wind. If the second player (50) went Mah Jong, everyone pays that player. Then plare one would receive 5 from player 3 (25-20) and 20 from player 4 (25-5). But also, player 3 would receive 15 from player 4 (20-5). Can anyone help me with a way of figuring this out? It has to ignore who went Mah Jong out of the 4.