Calculate risk matrix

[gavinburgess]

Hi in my survey I have two 'select one' list questions based on Likelihood (Certain to Rare) and Consequence(Negligible to Major). I'd like a message to popup with the resultant Risk Level based from the selection of these two fields. i.e. If Unlikely and Minor is selected, I want a popup to say Moderate Risk.

If not, can this be done with a note?

[JohnBickmore]

I have done this by using numbers as the choice names (first table) then using formulas in the relevant collumn to display the relevant risk 'notes'

I have only 4 risk class but should work with 5?

Liklihood	5	Almost Certain - Expected to occur regularly
Liklihood	4	Likely - Will probably occur
Liklihood	3	Possible - Might occur occasionally
Liklihood	2	Unlikely - Could happen at some time
Liklihood	1	Rare - May happen only in exceptional circumstances
Consequence	1	Negligible
Consequence	2	Minor
Consequence	3	Moderate
Consequence	4	Major
Consequence	5	Severe

${Liklihood}*${Consequence}>0.5 and ${Liklihood}*${Consequence}<=4

${Liklihood}*${Consequence}>4 and ${Liklihood}*${Consequence}<=10

${Liklihood}*${Consequence}>10 and ${Liklihood}*${Consequence}<=16

${Liklihood}*${Consequence}>16

${Liklihood}*${Consequence}>4 and ${Liklihood}*${Consequence}<=16