Sonic_blue_j
New Member
- Joined
- May 17, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I need a formula that will tell me how many orders I need to place of items, the problem is simply dividing isn't giving me what I need. -Unless I'm using something incorrectly-
They have as set order weight of, say, 20g; set by the retailer.
I need multiple quantities of the items, one being 38g and only 6g of another. Other entries are different weights, but I'll just use those 2 for my example.
The quantity is in column A and the retailer weight is in column B, with the output in column C.
What is the formula to tell me that I only need to place 1 order (of 20g) to cover the 6g and 2 orders (of 20g) to cover the 38g?
Obviously; I could just visually do this (as shown in the question above)....but that's not the point.
It can ignore the left-over amounts.
They have as set order weight of, say, 20g; set by the retailer.
I need multiple quantities of the items, one being 38g and only 6g of another. Other entries are different weights, but I'll just use those 2 for my example.
The quantity is in column A and the retailer weight is in column B, with the output in column C.
What is the formula to tell me that I only need to place 1 order (of 20g) to cover the 6g and 2 orders (of 20g) to cover the 38g?
Obviously; I could just visually do this (as shown in the question above)....but that's not the point.
It can ignore the left-over amounts.