-
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.
parcels
-
C
dashes needed excel 2016
i need 00901002409 as 009-01-002-409 with the preceding 0's when i try <colgroup><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="width:48pt" width="64"> </colgroup><tbody> 00901001120 =TEXT(G4,"???-??-???-???") 00901001122...- CrashOD
- Thread
- answer dashes formula parcels put
- Replies: 3
- Forum: Excel Questions
-
H
Formula needed to track the number of times each customer picked up 4 or more parcels on the preferred pick up day within a given time frame
Hi Everyone, We have a daily log of the number of parcels picked up by our customers. The number of parcels to be picked up ranges from 0 to a maximum of 5 per day. Customers are each assigned a pick-up day (Column C) if they are picking up 4 or more parcels. Row 1 shows the date the parcels...- Help101
- Thread
- customer day june parcels three criteria
- Replies: 6
- Forum: Excel Questions
-
E
Calculating Parcel costs within a band - if between, then sum
Hello, I have a weird one for you guys today..very interesting if you ask me! As an example, i am trying to work out the cost of 78 parcels, where from 0 - 25 parcels we charge $8.95 per parcel (Up to 25 parcels (8.95*25) = $223.75), 26 to 50 parcels (8.45*25) = $211.25 and 51 - 100 (7.95*28)...- enslaved
- Thread
- bands if statement parcels
- Replies: 6
- Forum: Excel Questions
