New Posts For Thread: Excel Formula Neededhttps://community.betfair.com/chit_chat/go/thread/view/94038/30356613/excel-formula-neededI've posted this in Genral Betting, but we all know it's quiet in there, so I thought I'd try my luck here.I have created a couple of spreadsheets for recording bets. Back, Lay, etc but mainly for level stakes or backing a percentage of a bank.What IGood question Foinavon.https://community.betfair.com/chit_chat/go/thread/view/94038/30356613/excel-formula-needed?post_id=541626061#541626061Good question Foinavon.Sat, 27 Sep 2014 18:32:54 -0500The formula for H3 is 10/(I3-1)Why do you need to bother when Betfair do it for you?https://community.betfair.com/chit_chat/go/thread/view/94038/30356613/excel-formula-needed?post_id=541625605#541625605The formula for H3 is 10/(I3-1)Why do you need to bother when Betfair do it for you?Sat, 27 Sep 2014 17:27:40 -0500just open the help file and search for "goal seek" and it should explain it there - but basically you want to make the cell with the liability always have a value of 10.00 by altering the value of H3 using a calculation on H3 & I3https://community.betfair.com/chit_chat/go/thread/view/94038/30356613/excel-formula-needed?post_id=541625071#541625071just open the help file and search for "goal seek" and it should explain it there - but basically you want to make the cell with the liability always have a value of 10.00 by altering the value of H3 using a calculation on H3 & I3Sat, 27 Sep 2014 16:38:00 -0500I've never even heard of that function. Like I said, I'm quite a novice.I guess it's probably best to do it manually then.https://community.betfair.com/chit_chat/go/thread/view/94038/30356613/excel-formula-needed?post_id=541625001#541625001I've never even heard of that function. Like I said, I'm quite a novice.I guess it's probably best to do it manually then.Sat, 27 Sep 2014 16:29:40 -0500If I understand you correctly, H3 must be a variable based on the odds available with a fixed stake of £10? In which case I think you would need to use the goal seek functionhttps://community.betfair.com/chit_chat/go/thread/view/94038/30356613/excel-formula-needed?post_id=541624933#541624933If I understand you correctly, H3 must be a variable based on the odds available with a fixed stake of £10? In which case I think you would need to use the goal seek functionSat, 27 Sep 2014 16:22:12 -0500ficed liability laying is the way to go ....https://community.betfair.com/chit_chat/go/thread/view/94038/30356613/excel-formula-needed?post_id=541624577#541624577ficed liability laying is the way to go ....Sat, 27 Sep 2014 15:44:28 -0500I've posted this in Genral Betting, but we all know it's quiet in there, so I thought I'd try my luck here.I have created a couple of spreadsheets for recording bets. Back, Lay, etc but mainly for level stakes or backing a percentage of a bank.What Ihttps://community.betfair.com/chit_chat/go/thread/view/94038/30356613/excel-formula-needed?post_id=541624513#541624513I've posted this in Genral Betting, but we all know it's quiet in there, so I thought I'd try my luck here.I have created a couple of spreadsheets for recording bets. Back, Lay, etc but mainly for level stakes or backing a percentage of a bank.What ISat, 27 Sep 2014 15:36:48 -0500