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 st...
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.