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.