I am trying to to use excel to calculate how much to bet depending on varying odds to always get a profit of 100 back...but I have been struggling to get the formula right and would really appreciate someone's help!
Basically, if the decimal odds is 2.00 and I want to make a hundred pounds profit I would have to bet £100, but how do I make a formula in excel that calculates this for me so that I can do it for any odds? It seems so simple, but yet I can't seem to get my head around it.
If decimal odds are in A1 try this formula in B1
=100/(A1-1)
Audere est facere
Hello Jojomama
Welcome to hte forum
if the decimal number is 3.00. what is your bet? is it 150 ?
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks