Forum Discussion

Amandolim's avatar
Amandolim
Copper Contributor
Apr 28, 2020

Excel Risk Register I need the rating to calculate automatically

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 (-:
excel
Formulas and Functions

1 Reply

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Apr 29, 2020

    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

     

Resources