+ Reply to Thread
Results 1 to 2 of 2

Cell outcome dependent on multiple other variables (text and number)

  1. #1
    Registered User
    Join Date
    Manchester, UK
    MS-Off Ver

    Cell outcome dependent on multiple other variables (text and number)


    I'm trying to create a formula to get a cell outcome based on multiple different variables that are number of text.

    So the outcomes could be

    Outcome 1
    Outcome 2
    Outcome 3
    Outcome 4

    And these outcomes based on multiple variables like:

    Product type
    Product spec
    Product amount
    Product amount two

    The outcomes would be different based on the "product type", "product spec", if product amount two is less than "product amount", or above "product amount" another outcome.

    Also dependent on the variables I would like the possibility to be able to combine outcomes.

    Help would greatly be appreciated.


  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403

    Re: Cell outcome dependent on multiple other variables (text and number)

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help 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. Replies: 4
    Last Post: 09-21-2022, 10:06 AM
  2. Outcome of formula to post as text instead of number if number <1
    By thcecil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2015, 08:20 PM
  3. [SOLVED] Populating a drop down list dependent on multiple matching variables
    By Sardaukar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2013, 02:48 AM
  4. [SOLVED] outcome of a cell dependent an value of a set of 3 cells
    By matwalker in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2013, 11:08 AM
  5. Bar or column plot 7 dependent variables with multiple data points in each?
    By CateFranklin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2011, 09:27 PM
  6. A text number with exactly 6 digits in the final outcome
    By mjwillyone in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-06-2009, 12:26 AM
  7. Different outcome for drop down box variables
    By Frankiemillion in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-09-2008, 11:32 PM

Tags for this Thread


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