Help!!

[Benny]

I'm trying to write a formula to update the bank and calculate my next bet. This is for my greyhound system that continues to win.

Something simple will do.

[Crackone]

Need more info Benny. You betting % of bank? need it rounded if betting with Tab,bookie or betfair?

[Benny]

Need more info Benny. You betting % of bank? need it rounded if betting with Tab,bookie or betfair?

2% of the bank rounded to nearest whole $1 using my bookie

[Crackone]

Starting bank $500 you can change to what you like, just copy formulas, if this helps.

Sheet1

<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 84px;"><col style="width: 64px;"><col style="width: 77px;"><col style="width: 77px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>A</td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td><td>H</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td>next bet</td><td>race</td><td>dog</td><td>bet</td><td>place </td><td>price</td><td>win/loss</td><td>balance</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td style="text-align: right;">10</td><td style="text-align: right;">1</td><td>goodthing</td><td style="text-align: right;"> $ 10.00 </td><td style="text-align: right;">1</td><td style="text-align: right;">3.2</td><td style="text-align: right;">22</td><td style="text-align: right;">522</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="text-align: right;"> $ 11 </td><td style="text-align: right;">2</td><td>wins</td><td style="text-align: right;"> $ 11 </td><td style="text-align: right;">1</td><td style="text-align: right;">5</td><td style="text-align: right;">44</td><td style="text-align: right;">566</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="text-align: right;"> $ 12 </td><td style="text-align: right;">3</td><td>dog</td><td style="text-align: right;"> $ 12 </td><td style="text-align: right;">3</td><td style="text-align: right;">3</td><td style="text-align: right;">-12</td><td style="text-align: right;">554</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="text-align: right;"> $ 12 </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); font-family: Arial; font-size: 10pt; background-color: rgb(255, 252, 249); color: rgb(0, 0, 0);"><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>A2</td><td>=0.02*500</td></tr><tr><td>G2</td><td>=IF(E2=1,(D2*F2)-D2,-D2)</td></tr><tr><td>A3</td><td>=ROUNDUP(0.02*H2,0)</td></tr><tr><td>D3</td><td>=A3</td></tr><tr><td>G3</td><td>=IF(E3=1,(D3*F3)-D3,-D3)</td></tr><tr><td>H3</td><td>=H2+G3</td></tr><tr><td>A4</td><td>=ROUNDUP(0.02*H3,0)</td></tr><tr><td>D4</td><td>=A4</td></tr><tr><td>G4</td><td>=IF(E4=1,(D4*F4)-D4,-D4)</td></tr><tr><td>H4</td><td>=H3+G4</td></tr><tr><td>A5</td><td>=ROUNDUP(0.02*H4,0)</td></tr></tbody></table></td></tr></tbody></table>

Excel tables to the web >> Excel Jeanie HTML 4 (http://www.excel-jeanie-html.de/index.php?f=1)

[ixlat0]

excellent reply Crackone

instead of ROUNDUP i suggest =FLOOR(0.02*H2+0.5,1) as this would make the bet 2% of the bank rounded to "nearest" whole $1

have the best day!

[Crackone]

Thanks for the tip.

Cheers

[ixlat0]

for Benny's sake i think i should point out that there is nothing wrong with using ROUNDUP -- my tip was in adopting a 0.5 adjustment to the equation -- i suggested using FLOOR as an alternative -- the same thing could also be achieved using INT -- the following all make the bet 2% of the bank rounded to "nearest" whole $1 (where cell H2 is the bank)

=ROUNDUP(0.02*H2-0.5,0)

=FLOOR(0.02*H2+0.5,1)

=INT(0.02*H2+0.5)