8th March 2018, 07:56 PM
|
|
Member
|
|
Join Date: Sep 2011
Posts: 1,517
|
|
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)) |