Expand on carton count

		Microsoft Office Forums > Microsoft Excel > Excel
Expand on carton count

FAQ

Mark Forums Read

Thread Tools

Display Modes

07-06-2017, 04:28 PM

Kubi

Windows XP Expand on carton count

Office XP

Advanced Beginner

Join Date: May 2017

Posts: 34

Expand on carton count

can you help me expand on this further by adding a pallet count to this i.e. 30 full boxes = 1 pallet

Thanks.

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

Edit Mod

This post is related to https://www.msofficeforums.com/excel...pack-qtys.html

Last edited by Pecoflyer; 07-07-2017 at 08:42 AM. Reason: Cut thread

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to expand the gridlines	Shahir Arifin	Word	2	11-25-2016 10:40 AM
Getting the Count formula to count all rows	Jennifer Murphy	Word Tables	11	08-23-2016 09:37 PM
How not disable expand/collapse	LVP	Word	3	12-21-2014 12:12 PM
Expand a Word table	SMT	Word VBA	2	04-11-2011 04:40 AM
Grouping - expand all	ejohns	Excel	0	07-17-2009 07:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:21 AM.