Assistance with formula

We were all new to Bet Angel once. Ask any question you like here and fellow forum members promise not to laugh. Betfair trading made simple.
Post Reply
Alpha322
Posts: 932
Joined: Fri Oct 30, 2009 4:45 pm

Hi
all if i show odds of 8.4 in one column and i want another column to show 11.0 as a result of the 8.4 what is the sum for this, any spreadsheet mathamaticians,
User avatar
Dublin_Flyer
Posts: 847
Joined: Sat Feb 11, 2012 10:39 am

If cell A1 is your 8.4 and you want cell B1 to be 11.0 then cell B1 should contain =A1*1.31
It gives 11.004 to be exact but 1 decimal place gives 11.0

Kind of hard to tell what you're doing though, 7.4 or 9.4 with the same formula will result in 9.7 and 12.3 respectively.

In a lay to back strategy, they all result in roughly 22-23% profit greened up.
Alpha322
Posts: 932
Joined: Fri Oct 30, 2009 4:45 pm

Dublin_Flyer wrote:If cell A1 is your 8.4 and you want cell B1 to be 11.0 then cell B1 should contain =A1*1.31
It gives 11.004 to be exact but 1 decimal place gives 11.0

Kind of hard to tell what you're doing though, 7.4 or 9.4 with the same formula will result in 9.7 and 12.3 respectively.

In a lay to back strategy, they all result in roughly 22-23% profit greened up.
Thanks mr Flyer
Post Reply

Return to “Bet Angel for newbies / Getting started”