Hi Tommy, I'm glad you like the spreadsheet!
The formula you have calculated above gives the decimal multi odds of 1.88. If you have set the workbook to American odds in the Settings worksheet this number would need to be converted back to American odds.
If the decimal multi odds are less than 2.00 then you need to convert it back to American odds as follows:
=-100/((100/550+1) * (100/170+1) - 1)
In this case you get -114.02.
If you place parlay/multi wagers regularly then data entry could be tedious because the formulas depend on whether the American odds are above or below 2.00 in decimal odds.
I recommend you download the following workbook and then insert it as a new sheet in your betting tracker:
http://www.aussportsbetting.com/2012...ator_v1_0.xlsx
I've only just made it now so there may be a few bugs, but it would provide a convenient means of calculating parlay/multi odds when using the spreadsheet with American odds. My recommendation is to calculate the American parlay odds using the sheet and use Copy, then 'Paste Values' into your Bets worksheet to avoid any rounding errors.
Hope that helps! Let me know if you have further problems or questions.
Bookmarks