Create IFS function using multiple cells

Copper Contributor

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?

1 Reply

That's like

=IFS(
   (A1=Medium Potential)*(B1=Achieves), Box 5,
   (A1=Medium Potential)*(B2= Occassionally Exceeds),Box 3...