recognize outer/inner pack qty's

xor · #1 05-11-2017, 10:00 PM

With outgoing stock in A2 and pack size in B2, try:

=INT(A2/B2)&" full box of "&B2&" and "&MOD(A2,B2)&" inner's"

Kubi · #2 05-12-2017, 12:05 AM

Quote:

Originally Posted by xor

With outgoing stock in A2 and pack size in B2, try:

=INT(A2/B2)&" full box of "&B2&" and "&MOD(A2,B2)&" inner's"

Awesome thank you that works perfectly. Now to make it a bit trickier would it be possible to add a cell that adds the full carton and inner pick to return a single number?

xor · #3 05-12-2017, 12:32 AM

Maybe like the attached

Kubi · #4 05-12-2017, 12:34 AM

Quote:

Originally Posted by xor

Maybe like the attached

Sweet thank you, I new how to do it but couldn't figure it out. That k you for that.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Spell Checker does not recognize mistakes	Suha	Word	6	10-18-2015 01:10 AM
Remove outer circle from a radial chart.	jdavid10	Excel	0	11-20-2013 09:01 PM
Outlook Goes Into Outer Space	abraxis	Outlook	0	05-08-2013 08:50 AM
Word does not recognize carets	stegngas	Word	1	12-07-2012 08:30 PM
Can't get formula to recognize correct data	cklassen	Excel	1	05-19-2012 01:25 AM