+ Reply to Thread
Results 1 to 3 of 3

Calculate How many "Kits" I can make from several smaller items

  1. #1
    Registered User
    Join Date
    08-08-2014
    Location
    Mississippi
    MS-Off Ver
    2010
    Posts
    6

    Question Calculate How many "Kits" I can make from several smaller items

    Hi there!

    I'm trying to use a cell to show the number of "kits" able to be made by calculating how many of each component there are, summing those up, and showing the number of kits that could be made. It seems like a somewhat simple task, but I am completely stumped so far.

    For example, assuming 5 of each Component 1 and 2 are used to make 1 Kit, see the following:

    Component 1 Component 2
    10 10
    Kits Available 2


    I am trying to calculate the "Kits Available" in this example. Any ideas?
    Last edited by BowtieAccountant; 08-08-2014 at 12:48 PM. Reason: Solved

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Calculate How many "Kits" I can make from several smaller items

    =min(quotient(a2,5),quotient(b2,5))

    Quotient returns the integer portion of the division, MIN pulls the smallest of the group.

    If you had 99/5 = 24.xx and 32/5 = 6.xx, the MIN of the two components would be 6. Six whole kits.
    Attached Files Attached Files
    Last edited by daffodil11; 08-08-2014 at 12:40 PM. Reason: elf blood
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    08-08-2014
    Location
    Mississippi
    MS-Off Ver
    2010
    Posts
    6

    Re: Calculate How many "Kits" I can make from several smaller items

    Perfect, thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Moving 30 days and older messages from "Sent Items" to "Deleted Items"
    By bandera in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2014, 07:09 AM
  2. Replies: 4
    Last Post: 01-28-2011, 03:01 PM
  3. Replies: 1
    Last Post: 07-16-2010, 02:44 AM
  4. Replies: 2
    Last Post: 03-02-2009, 04:32 AM
  5. [SOLVED] If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM

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