Forum Discussion

amichaluk's avatar
amichaluk
Copper Contributor
Feb 14, 2019

Create IFS function using multiple cells

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?

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 14, 2019

    That's like

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

Resources