Assuming total in A1 you can use this formula to give total commission
=A1*70%-MIN(N(A1),10000)*(70%-60%)
Assuming total in A1 you can use this formula to give total commission
=A1*70%-MIN(N(A1),10000)*(70%-60%)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks