Home

Create IFS function using multiple cells

%3CLINGO-SUB%20id%3D%22lingo-sub-340026%22%20slang%3D%22en-US%22%3ECreate%20IFS%20function%20using%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-340026%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI'm%20trying%20to%20build%20an%20IFS%20function%20that%20combines%20two%20cells.%20For%20example%2C%20if%20cell%20A1%20is%20Medium%20Potential%20and%20cell%20B1%20is%20Achieves%20then%20the%20result%20should%20be%20Box%205%20(this%20is%20from%20a%209-Box%20grid).%20If%20A1%20is%20Medium%20Potential%20and%20cell%20B2%20is%20Occassionally%20Exceeds%2C%20then%20the%20result%20should%20be%20Box%203%20and%20so%20forth%20(there%20are%209%20scenarios).%20Is%20this%20possible%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-340026%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-340034%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20IFS%20function%20using%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-340034%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20like%3C%2FP%3E%0A%3CPRE%3E%3DIFS(%0A%20%20%20(A1%3DMedium%20Potential)*(B1%3DAchieves)%2C%20Box%205%2C%0A%20%20%20(A1%3DMedium%20Potential)*(B2%3D%20Occassionally%20Exceeds)%2CBox%203...%20%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
amichaluk
Occasional Visitor

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