View Single Post
  #3  
Old 8th March 2018, 07:56 PM
UselessBettor UselessBettor is offline
Member
 
Join Date: Sep 2011
Posts: 1,474
Default

Quote:
Originally Posted by Shaun
=if(A1<0,A1,A1*.95)


Yep Shaun has it right there. If your using OpenOffice instead of Excel you would just use ; instead of ,

If you are doing it on Aus racing I suggest using the real commission per race which varies. If your not sure then default to 0.935 (6.5% commission) for testing.


To sightly improve it :

=if(A1<0,A1,ROUNDDOWN(A1*.95,2))
Reply With Quote