+ Reply to Thread
Results 1 to 2 of 2

Equation for counting boxes used. Please help!!!!

  1. #1
    Registered User
    Join Date
    02-19-2011
    Location
    california, United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    Equation for counting boxes used. Please help!!!!

    I work at a packaging company and Im trying to impress my boss by creating a spreadhseet that can calculate how many boxes will be needed to pack an order. Any help would be greatly appreciated. I need help creating a excel spread sheet that will give box sizes a value. Then the quantity ordered be divided by the value for each of the four box sizes. Then the decimal left over be converted to a whole number. Then all numbers of each box size combined. I know it is confusing but I know what Im trying to do. I just dont know what formulas to use. If you are willing to help, I can explain further. Thank you.

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Equation for counting boxes used. Please help!!!!

    We're happy to help (we love this stuff)

    Can you give us some examples and calculations?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1