Previous Topic Next Topic

What funtion/s should do I need

Solved/Closed
BJ - 13 May 2010 à 08:22
 BJ - 17 May 2010 à 08:05
I'm working on tool for a user to input a qty of items, then calulate the number of cartons required.

The cartons come in 1, 5 & 20 unit packs.

If a user asks for 56, how do i calculate in excel/VBA to get the answer of 2 x 20, 3 x 5 & 1 x 1?

BJ

2 responses

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
13 May 2010 à 08:46
Use mod function 

Twenties = (56 - (56 Mod 20)) / 20
NextBox = 56 Mod 20


Fives = (NextBox - (NextBox Mod 5)) / 5
NextBox = NextBox Mod 5

Ones = NextBox
Réponse 2 / 2
BJ
17 May 2010 à 08:05
Thanks for your help on this