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... 
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies