Excel Risk Register I need the rating to calculate automatically

[Amandolim]

I have 2 columns with drop down tables. Risk Consequence
Likelihood

Depending on which are selected I need the third columns to calculate the RISK rating. See attached image. Anybody know what formula to use?

I’m desperate for help I’ve been trying for ages (-:

[#2]

Hi @Amandolim 

I'd set it up like this  (I've attached an example file)

Hope that helps

Wyn

MVP

Australia UTC+ 8

If this answer was the best response please click the button

I also happily accept likes