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.
Bookmarks