-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
deliveries
-
D
Auto sum numbers based on previous number and a given number
Hi, I have a delivery company and want to create an incentive tracking sheet. My drivers will start accumulating fixed commissions after a certain number of deliveries (below chart); <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody>...- daddydool
- Thread
- aed10.00 deliveries driver incentive total
- Replies: 3
- Forum: Excel Questions
-
A
Combining IF and INDEX functions...I think
Unable to post attachments but numbers on bottom.. 1. I have two sets up numbers 2. As one goes up, the other comes down, and vice versa 3. If they are all pickups, I need to "mark red" if they go over the max amount (68,000) 4. If they are all deliveries, I need to "mark red" if they go over...- ajstole
- Thread
- 000 102 deliveries red
- Replies: 4
- Forum: Excel Questions
-
J
Calculate an average number of days or weeks between deliveries
I have a large spreadsheet. column A has sequential list of dates 2005 - current date. Column G has entries for delivery (numerical amount) on the actual delivery date (corresponding with Column A). I would like to determine the average number of days/weeks between deliveries. All cells in...- Joeclupis
- Thread
- average between events column date deliveries delivery
- Replies: 3
- Forum: Excel Questions
