Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-11-2017, 10:00 PM
xor xor is offline recognize outer/inner pack qty's Windows 10 recognize outer/inner pack qty's Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
recognize outer/inner pack qty's 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
recognize outer/inner pack qty's Word does not recognize carets stegngas Word 1 12-07-2012 08:30 PM
recognize outer/inner pack qty's Can't get formula to recognize correct data cklassen Excel 1 05-19-2012 01:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft