+ Reply to Thread
Results 1 to 4 of 4

Populate a cell based on 4 possible outcomes in two other cells

  1. #1
    Registered User
    Join Date
    11-15-2009
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Populate a cell based on 4 possible outcomes in two other cells

    IF, ISNA, MATCH in combination ? Populate a cell based on 4 possible outcomes
    HI I hope someone can help me with this. I cannot work out what combination of functions I need in order to populate a cell based on two other cells.

    E.G.
    Cell A1 has a number between 1 and 10. A number less than 6 should return a "LOW" in cell A3, otherwise "HIGH" which I have done with =IF(A1<6, "LOW","HIGH"). Similarly for numbers in cell A2 returning "LOW" or "HIGH" in cell A4 using a similar IF statement. I now want to populate cell A5 depending on the 4 possible combinations of outcomes in A3 and A4.

    I want A5 to contain "A" if A3 and A4 both contain "LOW" and "B" if both A3 and A4 contain "HIGH", "C" if A3 contains "LOW" and A4 contains "HIGH" and finally "D" if A3 contains "HIGH" and A4 contains "LOW".

    I am trying to figure out whether there is a combination of functions that create the logic I need somehow - maybe in IF,ISNA,MATCH ?

    (Or i guess I could work directly off the numbers column but I imagine the logic to be the same/similar)

    Can anyone help ? Thanks.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Populate a cell based on 4 possible outcomes in two other cells

    maybe this

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-15-2009
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Populate a cell based on 4 possible outcomes in two other cells

    Excellent. That works. you have no idea how thing I have been trying to work that out !!! So simple when you know how. Thank you so much.

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Populate a cell based on 4 possible outcomes in two other cells

    In case you want to color code your results, select all the result cells and then click

    Format - Conditional Formatting -

    Cell Value Is - equal to - "A" - Format button - set font or background color - click OK

    click Add and then

    Cell Value Is - equal to - "B" - Format button - set font or background color - click OK

    click Add and then

    Cell Value Is - equal to - "C" - Format button - set font or background color - click OK

    That's as many conditional formats as Excel 2003 will allow. But after you finish the conditional formatting dialog, select the cells and set the standard format to a fourth color, which should logically only be visible if the value of the cell is anything other than A, B or C, so most likely D or nothing.

    hth

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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