Forum Discussion
Excel formula warehouse thing.
Hello,
My question (as a newbee) is:
It's a warehouse thing.
I have the number of cartons on a pallet (yellow), number of cartons in stock beginning of the week (green) and number of cartons in stock at the end of the week (blue).
What formula do I need to calculate the number of pallets at the end of the week (red)?
So in this example (red) should be:
If blue is 0 it should be 0
If blue is 1-9 it should be 1
If blue is 10-18 it should be 2
And so on.
| Client | Week 01 | ||||||||
| # on pallet | #begin | ma | di | wo | do | vr | #end | # pallets | |
| Article | 9 | 18 | 1 | 2 | 15 | ? | |||
Hope to hear from anyone!
2 Replies
Let's say #end is in I2 (and down).
The formula for the number of pallets is
=QUOTIENT(I2+8, 9)
With Dutch system settings:
=QUOTIENT(I2+8; 9)
Hello Hans,
I made a very small adjustment but this was exactly what I was looking for.
It works like a charm, you're the best!
Thanks for the very quick response.
