Excel Risk Register I need the rating to calculate automatically

%3CLINGO-SUB%20id%3D%22lingo-sub-1342072%22%20slang%3D%22en-US%22%3EExcel%20Risk%20Register%20I%20need%20the%20rating%20to%20calculate%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1342072%22%20slang%3D%22en-US%22%3EI%20have%202%20columns%20with%20drop%20down%20tables.%20Risk%20Consequence%3CBR%20%2F%3ELikelihood%3CBR%20%2F%3E%3CBR%20%2F%3EDepending%20on%20which%20are%20selected%20I%20need%20the%20third%20columns%20to%20calculate%20the%20RISK%20rating.%20See%20attached%20image.%20Anybody%20know%20what%20formula%20to%20use%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%E2%80%99m%20desperate%20for%20help%20I%E2%80%99ve%20been%20trying%20for%20ages%20(-%3A%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1342072%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1346431%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Risk%20Register%20I%20need%20the%20rating%20to%20calculate%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1346431%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F639094%22%20target%3D%22_blank%22%3E%40Amandolim%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20set%20it%20up%20like%20this%26nbsp%3B%20(I've%20attached%20an%20example%20file)%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20888px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F187437i5B630EC4541A7F10%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EHope%20that%20helps%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EWyn%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EMVP%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EAustralia%20UTC%2B%208%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%22%3EIf%20this%20answer%20was%20the%20best%20response%20please%20click%20the%20button%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%22%3EI%20also%20happily%20accept%20likes%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
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 (-:
1 Reply
Highlighted

Hi @Amandolim 

 

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

 

 

Hope that helps

 

Wyn

MVP

Australia UTC+ 8

 

If this answer was the best response please click the button

I also happily accept likes