Complex Nested Condition

Hi,
I need to update the complexity column based on the individual or combination of values from another set of fields. Please see below:

A1 = Familiarity
B1 = Complexity
C1 - Stability

Conditions and Results:

Familiarity - High / Medium, Complexity - Low, Stability - High
Result to Update in D1 - "Low"

Familiarity - Low, Complexity is High / Medium, stability - High / Medium
Result to Update in D1 - "Medium"

Familiarity - Low / Medium, Complexity - High / Medium, Stability - Low
Result to Update in D1 - "High"

Appreciate your help.

Thanks,
Venkat R.

Hi,
Many thanks for the help. However I tried to run the formula and I found some cells are not getting populated. Attached is the sheet where i tried your solution.

Anything I am missing.

Thanks again for your help.

Regards,
Venkat R.

Hi,
Apologies, yes I overlooked these scenarios. Thanks for pointing it out. I will try to include these conditions in and give a try.

Thanks,
Venkat R.

Hi Glen,
I have to admit this requires exceptional skills to arrive at this solution I tried adding the conditions myself but could not succeed. Would it be possible to add the following condition to the existing query:
Low-Low-High = Medium
Medium-High-Medium= Medium
Low-Low-Medium = Medium
High-Medium-High = Medium
Medium-Medium-High= Medium

Thanks,
Venkat R.