tommygunnz
New Member
- Joined
- Dec 20, 2017
- Messages
- 17
I'm trying to add a commission structure.
front and back gross. back gross is paid 10%
if the front gross is negative, the you subtract that from the back gross, then multiply x 10%
if the front gross is positive then no deduction needed.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 76px"><col width="74"><col width="75"><col width="69"></colgroup><tbody>
</tbody> G3 H3 I3 J3
so =I3-(G3<0)*(i3*.1) this excel says = $900
but its not right
should be
$5,000 back gross - ($-2000) front gross =$3000 * 10% = 300
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
front and back gross. back gross is paid 10%
if the front gross is negative, the you subtract that from the back gross, then multiply x 10%
if the front gross is positive then no deduction needed.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Front Gross | Back Gross | ||
Gross | Commission | Gross | Commission |
$ (2,000.00) | $ 250.00 | $ 5,000.00 |
<colgroup><col style="width: 76px"><col width="74"><col width="75"><col width="69"></colgroup><tbody>
</tbody>
so =I3-(G3<0)*(i3*.1) this excel says = $900
but its not right
should be
$5,000 back gross - ($-2000) front gross =$3000 * 10% = 300
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>