All Forums | Systems & Strategies

Excel Moneyline Payout Formula

Participants:
Search model icon
Views: 20799
Posts: 5
 
Veteran
Participation Meter
Joined: May, 2010
Posts: 3158
Posted: #1
Greetings

I am looking for the formula that will take the contents of an excel cell -123 or +123 and display the profit for a $100 bet. I already know that a $100 bet on +123 will be $123.00 profit and the profit on -123 is $81.00. -123 means you bet $123.00 to win $100.00 and +123 means you bet $100 to win $123.

Any help with a single formula to determine the payout for a $100 bet given a moneyline is greatly appreciated.

Thanks in advance.




 
Banned
Participation Meter
Joined: Apr, 2011
Posts: 109
Posted: #2

Hello,

Since you need to divide by 1.23 for the favorite line (-123) and multiply by 1.23 for the underdog line (+123) you may need to use 2 seperate cells.

In cell A1 Type Bet Amount

In cell B1 Type Odds

In cell C1 Type Fav Wins

In cell D1 Type Und Wins

In cell C2 Type "=(A2/B2)"

In cell D2 Type "=(A2*B2)"

Then in cell B2 enter your odds and in cell A2 enter your bet amount and the spread sheet should do the rest for you. I hope this is helps.

 
Prospect
Participation Meter
Joined: Jul, 2009
Posts: 86
Posted: #3
you could use the if function to make it 1 cell
if "odds+" this other "odds -" wise do this
like this
WIN or LOSS in a1
bet in b1
odds amount in c1
=IF(A1="w",IF(C1>0,(C1/100)*B1,-(100/C1)*B1),-B1)
if result is a Win takes odds and returns amount won not including original bet (add a"+b1" to BLUE)
if loss returns amount loss
 
Prospect
Participation Meter
Joined: Jul, 2009
Posts: 86
Posted: #4
=IF(A1="w",IF(C1>0,(C1/100)*B1+B1,-(100/C1)*B1+B1),-B1)
 
 
Prospect
Participation Meter
Joined: Nov, 2019
Posts: 208
Posted: #5

I have to figure this one out, 

All Forums | Systems & Strategies
About Us
Contact Us
Careers
Our Team
Brand
Testimonials
Betting Guides
Sportsbook Reviews
Sports Betting News
Podcasts
Responsible Gaming
Sports Betting
US Betting Sites
Canada Betting Sites
Canada Casinos
Best Betting Apps
Contests
Streak Survivor
King of Covers
Ultimate Race
Office Pools
The Covers community has
618,670
lifetime members worldwide
Covers 25 Years Logo Established in 1995,
Covers is the world
leader in sports
betting information.
Site Map Help Privacy Terms of Service youtube logo facebook logo twitter logo instagram logo linkedin logo google news logo
Covers is verified safe by: Evalon Logo GPWA Logo GDPR Logo GeoTrust Logo Evalon Logo
Copyright © 1995 - 2024 CS Media Limited All Rights Reserved.

If you choose to make use of any information on this website including online sports betting services from any websites that may be featured on this website, we strongly recommend that you carefully check your local laws before doing so.It is your sole responsibility to understand your local laws and observe them strictly.Covers does not provide any advice or guidance as to the legality of online sports betting or other online gambling activities within your jurisdiction and you are responsible for complying with laws that are applicable to you in your relevant locality.Covers disclaims all liability associated with your use of this website and use of any information contained on it.As a condition of using this website, you agree to hold the owner of this website harmless from any claims arising from your use of any services on any third party website that may be featured by Covers.