PDA

View Full Version : Excel Help

Benny
10th September 2007, 06:06 PM
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
=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)