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.

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

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

Sheet1

	A	B	C	D	E	F	G	H
1	next bet	race	dog	bet	place	price	win/loss	balance
2	10	1	goodthing	$ 10.00	1	3.2	22	522
3	$ 11	2	wins	$ 11	1	5	44	566
4	$ 12	3	dog	$ 12	3	3	-12	554
5	$ 12

Spreadsheet Formulas

Cell Formula A2 =0.02*500 G2 =IF(E2=1,(D2*F2)-D2,-D2) A3 =ROUNDUP(0.02*H2,0) D3 =A3 G3 =IF(E3=1,(D3*F3)-D3,-D3) H3 =H2+G3 A4 =ROUNDUP(0.02*H3,0) D4 =A4 G4 =IF(E4=1,(D4*F4)-D4,-D4) H4 =H3+G4 A5 =ROUNDUP(0.02*H4,0)

Excel tables to the web >> Excel Jeanie HTML 4

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!

__________________
never smile at a crocodile -- don't be taken in by his welcome grin

Thanks for the tip.

Cheers

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)

__________________
never smile at a crocodile -- don't be taken in by his welcome grin