Calculating Odss based on Win Pct

[Blargh]

I need an excel formula that can take the porbablilty % and calculate the american odds.

I can figure it out by trial and error or by pen, paper and algebra. But I want to have excel do it for me.

For example how can get Excel to calculate 60% = -150 for me?

[Dunder]

=IF(A1<=0.5,SUM((1/A1)*100)-100,SUM((1/(1-A1))*-100)+100)

Where A1 contains the probabilty e.g. 0.60

[runnershane14]

How do you calculate the win probability if you knew the line was -150? In other words what is the reverse formula -150 to .6?

[Dunder]

How do you calculate the win probability if you knew the line was -150? In other words what is the reverse formula -150 to .6?

=IF(A1>0,SUM(1/((A1+100)/100)),SUM(1-(1/((A1-100)/-100))))

Again where cell A1 contains the US odds.

[ljump12]

Was that really that hard to do for yourself? The only slightly complicated thing in there was an if statement... Learn excel, its the least you can do.

[Blargh]

Yes. That was hard to do by myself. That is why I posted the question.

[IrishTim]

I have a file that should help but having problems posting it here. PM with your e-mail if you want it blargh and I'll send it over to you.

[elgreco]

Thanks Dunder

[ScreaminPain]

Blargh...I've seen Tim's file (previously posted) and it is easily understood and self-explanatory. Take him up on his offer and save the file on your 'puter.

I have a file that should help but having problems posting it here. PM with your e-mail if you want it blargh and I'll send it over to you.