Formula To Show Result

[VinceF]

Help...I'm hoping the experts can solve this one.
I've tried referencing a table, multiple IF statements but there's way to many combinations...
I've exhausted my limited brain cells.

This is a golf game that results in a team earning points.
The team with the most points wins
A team may consist of 1 to 4 players
There may be from 1 to 3 places paid
There may be a situation where there's two or more teams tied for any given place
In this example there are two teams tied for 1st place. In this case both the the 1st place money and the 2nd place money would be added together and awarded to the two teams who tied for 1st place.

Thank You for your assistance...!

VinceF
Excel 2016

8-3 UNDER CONSTRUCTION TWO PLUS.xlsm
	A	B	C	D	E	F
1
2		TEAM	SCORE	RANK	PAY OUT
3
4		1	+35	4
5		2	+41	1	FALSE
6		3	+36	3	FALSE
7		4	+22	8	FALSE
8		5	+17	10	FALSE
9		6	+41	1	FALSE
10		7	+33	6	FALSE
11		8	+18	9	FALSE
12		9	+25	7	FALSE
13		10	+34	5
14
15
16		TOTAL POT	$500.00
17
18		# OF PLACES PAID	3	(This number may be 1,2 or 3)
19
20		# OF PLYRS IN GRP	4	(This number may be 1,2, 3 or 4)
21
22		# OF TIMES	1ST PLACE	2ND PLACE	3RD PLACE
23		LOW SCORE	2	0	1
24
25		PERCENTAGE OF TOTAL POT PAY OUT
26		1 PLACE	2 PLACE	3 PLACE
27		100	X	X
28		0.70	0.30	X
29		0.65	0.25	0.10
30
Sheet1

Cell Formulas
Range	Formula
E5:E12	E5	=IF($O5=1,$M$23, IF($O5=2,$N$23, IF($O5=3,$O$23)))
D4:D13	D4	=RANK(C4,$C$4:$C$13)
C23	C23	=COUNTIF(D4:D13,1)
D23	D23	=COUNTIF(D4:D13,2)
E23	E23	=COUNTIF(D4:D13,3)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E4:E13	Cell Value	contains "FALSE"	text	NO

 

[VinceF]

Lot's of views, no replies.
Let me know if I need to further explain what I need or ?

Thanks,
VinceF