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

               63 skids @ 2,400 and 1 skid @800

 

Id like this transferred to the work sheet in cells that read as: ___ of ___

And have it automate the above blank information in accordance to what the equation above would be. And to make it printable in numerical order.

 

Sorry if I am unclear but I am no where near an excel wiz.

 

Thank you

  • dscheikey's avatar
    dscheikey
    Bronze Contributor

    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