Forum Discussion
amichaluk
Feb 14, 2019Copper Contributor
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 ...
SergeiBaklan
Feb 14, 2019Diamond Contributor
That's like
=IFS( (A1=Medium Potential)*(B1=Achieves), Box 5, (A1=Medium Potential)*(B2= Occassionally Exceeds),Box 3...