New Posts For Thread: working out commission on excel helphttps://community.betfair.com/general_betting/go/thread/view/94082/23469638/working-out-commission-on-excel-helpusing this formula going all in from 200 backing 1.10's=sum(a1*1.1)*.95 the bit outside the bracket taking into consideration the 5% commission but its wrong, if i take it off the figures are right but dont include the 5% commission needed toTry=ROUNDDOWN(A1*1.1-(A1*0.1*0.05),2)https://community.betfair.com/general_betting/go/thread/view/94082/23469638/working-out-commission-on-excel-help?post_id=419159666#419159666Try=ROUNDDOWN(A1*1.1-(A1*0.1*0.05),2)Sat, 28 Nov 2009 18:47:46 -0600using this formula going all in from 200 backing 1.10's=sum(a1*1.1)*.95 the bit outside the bracket taking into consideration the 5% commission but its wrong, if i take it off the figures are right but dont include the 5% commission needed tohttps://community.betfair.com/general_betting/go/thread/view/94082/23469638/working-out-commission-on-excel-help?post_id=419159646#419159646using this formula going all in from 200 backing 1.10's=sum(a1*1.1)*.95 the bit outside the bracket taking into consideration the 5% commission but its wrong, if i take it off the figures are right but dont include the 5% commission needed toSat, 28 Nov 2009 17:28:09 -0600