Hi I am trying to create a worksheet where folks can document a risk assessment. They rate their risks by providing a numerical score for inherent risk that can range from 1 to 25 (in column N) and they can provide a numerical score control effectiveness that can range from 1 to 5 (in column O). Now what I would love to realize is that Column P called risk bucket will show 4 possible outcomes based on the values that were put in the other two columns. I have placed these outcomes on a separate tab in the worksheet and they look like this,
bucket sip.JPG
The outcome is based on the following heatmap
heat map.JPG
so for example a line with inherent risk value 12 and control effectiveness 4 would have to show MONITOR in column P.
Is this somehow possible with a formula? I could not find it
Another thing I want to do after this is done is actually plot these risk on the actual heatmap above in a separate tab in the excel but maybe I should open a new question for that ;-)
thanks for your help!
please note this question was also posted in another forum here
http://stackoverflow.com/questions/4...on-2-values-in
Bookmarks