Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
1 master carton contains 72 pieces
1 master carton has 6 inner cartons each with 12 pieces (6 x 12 = 72) I want to create a worksheet which when I enter a number of pieces it will show me in one box the number of full carton (72 pieces), in one box the number of part cartons, and in another box the number of individual pieces left. So for example enter 100 it would return in one 1 (mulitple of 72), in second box 2 (2 x 12 = 24) and in last box 4 (4 individual pieces) Any ideas? Regards Kinsey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookups with multiple answers | Excel Discussion (Misc queries) | |||
IRR monthly flows with multiple answers | Excel Discussion (Misc queries) | |||
multiple answers | Excel Worksheet Functions | |||
MATCH w/ multiple answers? | Excel Worksheet Functions | |||
IF function for multiple answers? | Excel Worksheet Functions |