Multiple variables determining an outcome

%3CLINGO-SUB%20id%3D%22lingo-sub-1727841%22%20slang%3D%22en-US%22%3EMultiple%20variables%20determining%20an%20outcome%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1727841%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20three%20variables%20which%20determine%20the%20outcome.%20What%20formula%20can%20I%20use%20to%20showcase%20the%20outcome%20if%20all%20three%20are%20independent%20variables%20and%20the%20outcome%20is%20not%20a%20function%20of%20any%20of%20them%3F%26nbsp%3B%3C%2FP%3E%3CP%3EE.g.%26nbsp%3B%3C%2FP%3E%3CP%3Ea%2Bb%2Bc%3DX%3C%2FP%3E%3CP%3EThe%20values%20of%20a%2C%20b%20and%20c%20are%20between%201-10.%20X%20is%20equal%20to%20Low%2C%20Medium%2C%20High%2C%20Very%20High.%20X%20is%20determined%20based%20on%20a%2Cb%2Cc%20but%20it%20isn't%20a%20mathematical%20formula.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1727841%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1728084%22%20slang%3D%22de-DE%22%3ESubject%3A%20Multiple%20variables%20determining%20an%20outcome%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728084%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F814480%22%20target%3D%22_blank%22%3E%40Alekhya_Boora%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20a%20small%20example%20of%203%20variables.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EINDEX(A1%3AE8%2CMATCH(A15%26amp%3BB15%2CA1%3AA8%26amp%3BB1%3AB8%2C0)%2CMATCH(C15%2CA1%3AE1%2C0))%22%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EArray%20formula%3A%20Complete%20the%20formula%20entry%20with%20Ctrl%20%2B%20Shift%20%2B%20Enter%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%223Variablen.JPG%22%20style%3D%22width%3A%20875px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223016i65387BA071D4F2E9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%223Variablen.JPG%22%20alt%3D%223Variables.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThe%20same%20example%20in%20German%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have three variables which determine the outcome. What formula can I use to showcase the outcome if all three are independent variables and the outcome is not a function of any of them? 

E.g. 

a+b+c=X

The values of a, b and c are between 1-10. X is equal to Low, Medium, High, Very High. X is determined based on a,b,c but it isn't a mathematical formula. 

1 Reply
Highlighted

@Alekhya_Boora 

 

Here is a small example of 3 variables.

{=INDEX(A1:E8,MATCH(A15&B15,A1:A8&B1:B8,0),MATCH(C15,A1:E1,0))}

Array formula: Complete the formula entry with Ctrl + Shift + Enter

 

3Variablen.JPG

The same example in German

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.