Feb 14 2019 03:12 PM
I'm trying to build an IFS function that combines two cells. For example, if cell A1 is Medium Potential and cell B1 is Achieves then the result should be Box 5 (this is from a 9-Box grid). If A1 is Medium Potential and cell B2 is Occassionally Exceeds, then the result should be Box 3 and so forth (there are 9 scenarios). Is this possible?
Feb 14 2019 03:21 PM
That's like
=IFS( (A1=Medium Potential)*(B1=Achieves), Box 5, (A1=Medium Potential)*(B2= Occassionally Exceeds),Box 3...