Forum Discussion

Knicky37's avatar
Knicky37
Copper Contributor
May 23, 2024

Help with a worksheet

Looking to have a spreadsheet that auto populated a total printable sheet count correlating to an equation.   Example: unit qty total = 152,000                 Units per skid= 2,400              ...
excel
dscheikey's avatar
dscheikey
Bronze Contributor
May 24, 2024

Knicky37 

I hope these two functions put you on the right track.

=INT(152000/2400) = 63
=MOD(152000/2400) = 800

=INT(152000/2400)&"  skids @2,400 and 1 skid @"&MOD(152000/2400) = "63 skids @ 2,400 and 1 skid @800"

 

Resources