I’m making a risk register for a safety app. As part of the register there’s a requirement for a severity (1-5) and likelihood (1-5) to be chosen for any given risk, which then determines a risk rating (H,M,L).
What would be a good way to have the risk rating self-calculate from the chosen severity and likelihood without writting masses of IF/And statements? Severity, likelihood and Risk Rating all would need to be visible as separate columns in the register (as evidence of thow the rating was determined).
The matrix is shown below.
Many thanks in advance!