excel help

[pat]

Im attempting to create an oddsline in excel but im not familiar with the formula to enter any suggestions
Hs#1=71.2 15%
HS#2=70 10%
HS#3=72.3 28%
HS#4=73 28%
HS#5=68 0%
Above figures show how i would like program to function:Lets say #s on left are my final calculations for each horse and %s on right are what i believe their chances of winning are based on highest to lowest #S I assign percentage to top 4 horses as follows 33%/23%/15%/10% providing each horse is at least 1 pt higher than next then i split
What formula will i enter in excel B1:B5

[TitanSooner]

the formula to convert %'s of a horses chance of winning to an odds line are simple:

say a horse has a 33% chance of winning..

(1 / .33) -1 = 2.030303 (or 2-1)

a horse with a 12.5% chance of winning..

(1 / .125) -1 = 7 (7-1)

formula would look something like this (if your % was in cell B1)
=1/B1-1

not sure if that's what you were looking for or not..

[pat]

thanks titan that helps but i was thinking more like having the excel program automatically assign the odds to the numbers

[K9Pup]

Im attempting to create an oddsline in excel but im not familiar with the formula to enter any suggestions
Hs#1=71.2 15%
HS#2=70 10%
HS#3=72.3 28%
HS#4=73 28%
HS#5=68 0%
Above figures show how i would like program to function:Lets say #s on left are my final calculations for each horse and %s on right are what i believe their chances of winning are based on highest to lowest #S I assign percentage to top 4 horses as follows 33%/23%/15%/10% providing each horse is at least 1 pt higher than next then i split
What formula will i enter in excel B1:B5

I don't think there is a simple formula to do what you want. IF the horses were listed from best to worst then you could easily compare 1 to the next. But since they are in horse order you would first need to rearrange them or otherwise determine the order. This can be done, but not with just one formula.

I would suggest a better (different at least) method. Why not just calculate the probs for ALL horses in the race? To do that you can simply divide each horse's score by the sum of all scores for this race. Logically the sum of the probs of all horses in a race should add up to 100%. In your example above the percentages would be 20.1%,19.7%,20.4%,20.6% and 19.2% .

[pat]

I was assigning my top 4 contenders 80% of the prob.but your suggestion will help tremendously. thank you