Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Calculation in excel using vb

Posted on 2011-09-08
Medium Priority
199 Views
Formula to calculate the betting amount

example
odds 1.10 in order for the user to get \$10 profit the calc bet would be \$100
pay out would be \$110 therefore \$10 profit

can anyone help with the formula

betcalc.xlsx
0
Question by:Jason
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 22

Accepted Solution

Thomasian earned 2000 total points
ID: 36508475
=D2/(A2-1)

Or

BetAmt = Profit / (Odds-1)
0

Author Closing Comment

ID: 36509441
Perfect just couldn't get my head around it
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…