+ Reply to Thread
Results 1 to 4 of 4

Fixed Profit formula/calculator for betting

  1. #1
    Registered User
    Join Date
    06-12-2014
    Posts
    1

    Fixed Profit formula/calculator for betting

    Hello,

    Quite simply I would like to determine the stake I would have to make for a fixed profit of eg. $50

    For example I put my odds (eg. $1.64) in one cell and that will automatically determine my stake in another cell to make $50 profit

    Thank you in advance

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    24,019

    Re: Fixed Profit formula/calculator for betting

    How would you do this manually? What is your logic? Explain it so that we can provide you with an excel solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Fixed Profit formula/calculator for betting

    I am assuming that for every $1 bet you get $1.64 back in your example (if you win). So the formula is
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    In your example
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    The answer in this case is 78.125. You would bet $78.125 at $1.64, which would return you $128.125, less your initial outlay of $78.125 leaving you with $50.
    Last edited by gak67; 06-12-2014 at 11:18 PM.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

  4. #4
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Fixed Profit formula/calculator for betting

    Message deleted.

+ 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. Fixed profit formula
    By clarkson01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2014, 03:40 AM
  2. [SOLVED] Working out betting sums to return a specific profit
    By jessecain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-14-2013, 07:24 AM
  3. Replies: 1
    Last Post: 10-09-2012, 08:40 AM
  4. Loan Calculator with Terms based on Fixed Payment not a fixed time frame.
    By cc4digital in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2012, 04:49 AM
  5. Profit Calculator
    By dandi10 in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 07-24-2010, 07:06 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