Hi All,
I have set boundaries for a commission based sheet..
Each pay periods is every 2 weeks so we will start at 1/1/2015-1/14/2015 to make it simple. Now here is the part I am stuck at..
If the sum of Column B is greater than 1000 between the pay period, I want to sum anything greater than 1000 at 80% so column C. I've tried using a helper column, but I keep getting stuck. In another sheet (I placed 2 in one so I can have it shown easier), I have the payroll dates.
The second pay period resets and the account rep needs to get over 1000 in gross profit to earn commission.
I am open to all suggestions. I am trying to avoid manually inputting them myself since this is just a small sample of thousands.
First Pay Period = 640
Second Pay Period = 160
Third Pay Period = 0
Here is my example.
<tbody>
</tbody>
If you have any questions to clear up any confusion, ask away!
Thanks in advance
Andrew
I have set boundaries for a commission based sheet..
Each pay periods is every 2 weeks so we will start at 1/1/2015-1/14/2015 to make it simple. Now here is the part I am stuck at..
If the sum of Column B is greater than 1000 between the pay period, I want to sum anything greater than 1000 at 80% so column C. I've tried using a helper column, but I keep getting stuck. In another sheet (I placed 2 in one so I can have it shown easier), I have the payroll dates.
The second pay period resets and the account rep needs to get over 1000 in gross profit to earn commission.
I am open to all suggestions. I am trying to avoid manually inputting them myself since this is just a small sample of thousands.
First Pay Period = 640
Second Pay Period = 160
Third Pay Period = 0
Here is my example.
A | B | C | D | E | A | B | C | D | |||
1 | DATE | GROSS PROFIT | 80% | Begin Date | 1/1/2015 | 1/15/2015 | 1/30/2015 | ||||
2 | 1/1/2015 | 400 | 320 | End Date | 1/14/2015 | 1/29/2015 | 2/13/2015 | ||||
3 | 1/4/2015 | 500 | 400 | Amount Owed | (formula) | (formula) | (formula) | ||||
4 | 1/7/2015 | 500 | 400 | ||||||||
5 | 1/12/2015 | 400 | 320 | ||||||||
6 | 1/18/2015 | 200 | 160 | ||||||||
7 | 1/22/2015 | 600 | 480 | ||||||||
8 | 1/26/2015 | 100 | 80 | ||||||||
9 | 1/28/2015 | 300 | 240 | ||||||||
10 | 1/31/2015 | 200 | 160 | ||||||||
11 | 2/2/2015 | 100 | 80 | ||||||||
12 | 2/5/2015 | 300 | 240 | ||||||||
13 | 2/8/2015 | 200 | 160 | ||||||||
14 | 2/15/2015 | 500 | 400 |
<tbody>
</tbody>
If you have any questions to clear up any confusion, ask away!
Thanks in advance
Andrew