Converting American Odds to Decimal - Excel Formula

[TtownDick]

Okay, I am NOT a sharp.
And this is my first visit here.
So NO flaming please.
I came here looking for a function to use in my Excel worksheet to convert American odds to decimal.

I THINK I came up with the equation, and wanted to share and make sure I got it right.
There were a couple of things that were either confusing or way over my head.
So I went back to work and came up with this:

Assuming A1 is the American Odds, In B1, input:

=IF(A1="","",IF(A1>0,(A1/100)+1,IF(A1<-1,(1+(A1*-1)))))

This also takes into account a if there is no number in A1, B1 will remain blank.

If you are looking for something like this, let me know if it works for you - or not.

ps. Roll Tide!

[oilcountry99]

Check this out

http://www.sportsbookreview.com/forum/handicapper-think-tank/29621-simple-vba-sports-betting-functions-template-excel.html

[smoke a bowl]

=IF(A1>0,100/(100+A1),-A1/(100+A1*-1)) This should work but guessing yours is fine as well.

[makman]

=IF(A1>0,100/(100+A1),-A1/(100+A1*-1)) This should work but guessing yours is fine as well.

but yours is not so fine...

[smoke a bowl]

No shit?

[Cookie Monster]

I have always used:
=IF(A1>0,1+A1/100,1-100/A1)