Say I have three Columns:
- Likelihood (1-5)
- Consequence (1-5)
- Risk Score (1-25)
The risk score is calculated based on multiplication of Likelihood and Consequence.I would also like a column that interprets the range of score in the Risk Score Column and provides one of the following four: Low, Medium, High Extreme.
Here is what I came with but can't seem to get it to work.
=IF(or([Risk Score]<="6","Low"), IF[Risk Score] >"6" or <="12","Medium"), IF[Risk Score] >"12" or <="19","High"), IF[Risk Score] >"19","Extreme")
Thanks!