david gabra
Member
Hi
Please can you assist with a smart if
i will have 3 columns ' impact' and 'likelihood'  and based on those number  I will have a derived risk.
I have no clue how to make it  please help
if impact is 1 and likelihood is 1 or 2 or 3 then 'minor' (risk)
if impact is 1 and likelihood is 4 then 'moderate' (risk)
if impact is 1 and likelihood is 5 then 'high' (risk)
if impact is 2 and likelihood is 1 or 2 then 'minor' (risk)
if impact is 2 and likelihood is 3 then 'moderate' (risk)
if impact is 2 and likelihood is 4 or 5 then 'high' (risk)
if impact is 3 and likelihood is 1 then 'minor' (risk)
if impact is 3 and likelihood is 2 then 'moderate' (risk)
if impact is 3 and likelihood is 3 or 4 then 'high' (risk)
if impact is 3 and likelihood is 5 then 'very high' (risk)
if impact is 4 and likelihood is 1 then 'moderate' (risk)
if impact is 4 and likelihood is 2 or 3 then 'high' (risk)
if impact is 4 and likelihood is 4 or 5 then 'very high'(risk)
if impact is 5 and likelihood is 1 or 2 or 3 then 'high' (risk)
if impact is 5 and likelihood is 4 or 5 then 'very high' (risk)
Thank you
David.
Please can you assist with a smart if
i will have 3 columns ' impact' and 'likelihood'  and based on those number  I will have a derived risk.
I have no clue how to make it  please help
if impact is 1 and likelihood is 1 or 2 or 3 then 'minor' (risk)
if impact is 1 and likelihood is 4 then 'moderate' (risk)
if impact is 1 and likelihood is 5 then 'high' (risk)
if impact is 2 and likelihood is 1 or 2 then 'minor' (risk)
if impact is 2 and likelihood is 3 then 'moderate' (risk)
if impact is 2 and likelihood is 4 or 5 then 'high' (risk)
if impact is 3 and likelihood is 1 then 'minor' (risk)
if impact is 3 and likelihood is 2 then 'moderate' (risk)
if impact is 3 and likelihood is 3 or 4 then 'high' (risk)
if impact is 3 and likelihood is 5 then 'very high' (risk)
if impact is 4 and likelihood is 1 then 'moderate' (risk)
if impact is 4 and likelihood is 2 or 3 then 'high' (risk)
if impact is 4 and likelihood is 4 or 5 then 'very high'(risk)
if impact is 5 and likelihood is 1 or 2 or 3 then 'high' (risk)
if impact is 5 and likelihood is 4 or 5 then 'very high' (risk)
Thank you
David.
Attachments

9 KB Views: 7