Multiple variables determining an outcome

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? 



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



Here is a small example of 3 variables.


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



The same example in German


I would be happy to know if I could help.



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.