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 ?
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks