Forum Discussion
how to apply formula to calculate average of risk in excel
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...
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.