OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)

- Horse Race Betting Systems (http://forums.ozmium.com.au/forumdisplay.php?f=10)

- - Excel Help (http://forums.ozmium.com.au/showthread.php?t=16533)

Benny

10th September 2007 06:06 PM

Excel Help

Can some help with a formula to calculate a bet of 3% of a $200 bank?

Usurper

10th September 2007 08:16 PM

Assume bank balance is in cell A1

=sum(A1*3/100)

SeeDee

10th September 2007 11:59 PM

And, if you want to round it to nearest 50c

=round(A1*3/100/5,1)*5

I know it should be A1*3/500, but the above is easier to follow.

stugots

11th September 2007 12:20 PM

for closest 0.50c

=CEILING(A1*0.03,0.5)

or closest $1.00

=CEILING(A1*0.03,1)

Benny

11th September 2007 07:09 PM

Now, say I wanted to bet up to 6 horses in the same race. Using a bank of $2000 bet 3% per race how would i find the amount to bet on each horse.

=CEILING(a1*0.03,1)/6

stugots

12th September 2007 07:37 AM

=CEILING(A1/6*0.03,1)

All times are GMT +10. The time now is 04:38 AM.