Odds
7
9
11
13
14
14
15
16
16
17
18
18
21
21
26
35
35
35
51
51
51
51
71
126


Bet
11
8.5
7
6.5
5.5
5.5
5.5
4.75
4.75
4.5
4
4
3.25
3.25
3.5
3
3
3
2
2
2
2
1.5
1
101

Winnings
77
76.5
77
84.5
77
77
82.5
76
76
76.5
72
72
68.25
68.25
91
105
105
105
102
102
102
102
106.5
126


Hi I'm new to excel programming but I was wondering if I could run a program to make all of the winnings column elements (above) greater than or as close as possible to the sum of the bets (101) in this case.
Any help would be greatly appreciated. (I'm investigating the mathematics of horse betting). Thanks in advance.