+ Reply to Thread
Results 1 to 2 of 2

automatic adjustments with multiple cells and multiple conditions

  1. #1
    Registered User
    Join Date
    03-18-2019
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    Excel 2013
    Posts
    1

    Lightbulb automatic adjustments with multiple cells and multiple conditions

    I know that you can use a nested "if" function to create multiple conditions and if all of them are met, it will create a certain result. i am looking for a formula that will take multiple conditions and produce different results based on the criteria.

    for example:
    if "condition a" then "result a"
    if "condition b" then "result b"
    if "condition c" then "result c"

    so lets say i have a column titled "kit type" if there are 5 different types of kits, i want to set it up to where once i enter the kit name into the column, it will reduce my stock of the individual items it takes to make that kit by a set amount.

    for example, if Kit 1 requires:
    2 of item A
    5 of item B
    10 of item C,

    and Kit 2 requires:
    3 of item A
    7 of item B
    2 of item C,

    i want to be able to type in "Kit 1" and then have my on count of item A reduced by 2, Item B reduced by 5 ,and item C reduced by 10. OR type in "Kit 2" and have my count of items A, B, and C, reduced by the respective amounts. How could i go about doing this?

    i hope this makes sense! thanks for the help!

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    19,046

    Re: automatic adjustments with multiple cells and multiple conditions

    Hello Aaron Wocher and Welcome to Excel Forum.
    Perhaps the following will be helpful.
    Inventory is kept at the top of the sheet and inventory amounts are populated using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The number of items needed for each kit as well as the number that will be received per restocking is listed in columns J:L
    The dates of sales/restocking are listed in A8:A20
    The Kit sold or Restock is displayed by data validation in B8:B20
    For future reference you will usually get faster results if you upload a sample that demonstrates what you want. You may have to manually mock up the expected outputs so that we can attempt to replicate them using formulas/code.
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Combining Text from multiple cells under multiple conditions
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 07:05 AM
  2. Combining Text from multiple cells under multiple conditions
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  3. Combining Text from multiple cells under multiple conditions
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  4. [SOLVED] Combining Text from multiple cells under multiple conditions
    By KNS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] Combining Text from multiple cells under multiple conditions
    By KNS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. [SOLVED] Combining Text from multiple cells under multiple conditions
    By KNS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Combining Text from multiple cells under multiple conditions
    By KNS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. Combining Text from multiple cells under multiple conditions
    By KNS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2005, 06:05 PM

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