PatrickThorne
New Member
- Joined
- Jul 31, 2019
- Messages
- 3
The printing company I work for is running into a lot of manual entry on excel to figure out shipping weights for freight and customer cost.
A quick example would be:
Book Quantity = 150
Book Weight (per unit) = .75lbs
A carton for the books weighs 1lb each. A carton can fit a finite amount of books. Currently, we have someone going in to manually multiply the book quantity by book weight, then determining how many cartons the job will take.
150*.75lbs=112.5lbs
One carton will hold 50 books. So 150/50=3 cartons.
112.5lbs+3lbs=115.5lbs
My question is, would there be a way to have a formula that would autofill in cells something along the lines of...
150*.75+(1<50, 2>50<100, 3>100<150) or something similar.
A quick example would be:
Book Quantity = 150
Book Weight (per unit) = .75lbs
A carton for the books weighs 1lb each. A carton can fit a finite amount of books. Currently, we have someone going in to manually multiply the book quantity by book weight, then determining how many cartons the job will take.
150*.75lbs=112.5lbs
One carton will hold 50 books. So 150/50=3 cartons.
112.5lbs+3lbs=115.5lbs
My question is, would there be a way to have a formula that would autofill in cells something along the lines of...
150*.75+(1<50, 2>50<100, 3>100<150) or something similar.