how to apply formula to calculate average of risk in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1931753%22%20slang%3D%22en-US%22%3Ehow%20to%20apply%20formula%20to%20calculate%20average%20of%20risk%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1931753%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20a%20table%20as%20below.%20You%20can%20see%20plat%20operation%20legal%2C%20compliance%20tab%20with%20ratings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20want%20to%20add%20a%20formula%20in%20Impact%20Rating%20to%20calculate%20the%20Risk%20automatically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eeg.%3C%2FP%3E%3CP%3E3%20High%20%3D%20High%20Impact%3C%2FP%3E%3CP%3E2%20Low%201%20High%20%3D%20Low%20Impact%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1931753%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi

 

i have a table as below. You can see plat operation legal, compliance tab with ratings.

 

i want to add a formula in Impact Rating to calculate the Risk automatically.

 

eg.

3 High = High Impact

2 Low 1 High = Low Impact

 

1 Reply

@sau007 

Just two samples is not enough to build the formula, entire logic is required for all possible combinations of High and Low. If no Medium at all, I'd build helper matrix with number of High vertically, Low horizontally, COUNTIF() them in table and return result by INDEX() from that matrix.