excel and staking?

[byepeeps]

I'm using a 1% of bank staking level. Now I want to have one day's racing at one level e.g. if 1% of bank is £15 then I want £15 on all bets for that day.

At the moment my spreadsheet adjusts the bank after every bet. So if one bet loses then it adjusts the bank for the rest of the day. As I won't be in during the day and won't be able to adjust my stakes for every bet, how do I work this into the spreadsheet and still be able to have a cumulative bank column?

[presto]

have the stake calculated in a cell at the top of the page, then enter the stake manually for the bets.

[mathare]

Your staking column says something like:
=0.01*<bank> at the minute
Assuming you have the date in column A then change the staking formula to:
=if(A2=A1,B1,0.01*<bank>)
where column B contains the stakes. Put that into row 2 and copy down. What it is doing is saying that if the date of this bet (A2) equals the date of the previous bet (A1) then use the same stake (B1) else recompute it.

Of course you need to change A1, A2, B1 etc to match the layout of your spreadsheet

[byepeeps]

Thanks both. I tried Mathare's one, as it means I don't have to type in the stake manually. Seems to be working.