+ Reply to Thread
Results 1 to 3 of 3

Calculate winnings by using fixed stake and odds

  1. #1
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Calculate winnings by using fixed stake and odds

    Hello. I hope someone can help me with this.
    I would like a formula to show the points won on a football match when the stake is fixed at 50000 points.
    For example, the odds for a match between Barcelona - Real Madrid might be 7/4 12/5 6/5
    If Barcelona win, the formula to work out the winnings would be 50000*7/4+50000
    The draw would be 50000*12/5+50000
    A win for Real Madrid would be 50000*6/5+50000

    If the result of the match in cell A1 is Barcelona 2-2 Real Madrid, how can I show the winnings in cell B1?

    Thank you.
    Last edited by tom hatten; 02-05-2015 at 01:35 PM.

  2. #2
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Re: Calculate winnings by using fixed stake and odds

    I've edited my first post in an attempt to make my problem more understandable. Hoping someone can help.
    Attached Files Attached Files
    Last edited by tom hatten; 02-05-2015 at 03:28 PM. Reason: Attachment added

  3. #3
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Re: Calculate winnings by using fixed stake and odds

    Hi. I've just added an attachment to post #2
    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Is there any formula to calculate a fixed increase with a fixed price?
    By ec4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2012, 12:15 PM
  2. Replies: 3
    Last Post: 08-31-2011, 09:11 AM
  3. Formula required to calculate betting odds/returns
    By jonrayworth in forum Excel General
    Replies: 0
    Last Post: 07-13-2010, 08:14 AM
  4. [SOLVED] How to calculate odds in excel (for instance matching pairofdice)
    By Diceroller in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-09-2006, 06:00 PM
  5. Stake calculator
    By Marie1uk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-16-2006, 08:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1