![]() The INDEX function is used to retrieve value from a 2D array using the row and column index. In those cases, this formula will be a life saver. But in reality you may have a bigger matrix which can be used manually. Here we used a small matrix to illustrate the use. This value can be used to make important decisions. = INDEX (D4:H8, MATCH (D11, D3:H3, 0), MATCH (D12, C4:C8,0))Īs you can see it has returned a risk value. We need to get the Risk value of this combination from the risk matrix above.įor this, we use the above mentioned generic formula in cell D13. In the image above we have certainty levels in D11 and Impact level written in D12. Impact_headers: This is the range that contains the impact labels. Matrix : This is the entire matrix value range (excluding headers).Ĭertainty: This is the certainty level label.Ĭertainty_headers: This is the range that contains the certainty level labels. The generic formula for retrieving the risk value will be: = INDEX ( matrix, MATCH ( certainty,certainty_headers, 0), MATCH ( impact,impact_headers ,0)) We can use the INDEX and MATCH function to retrieve values from this table. Now that our RISK matrix is ready, let's learn how to retrieve values from it by providing Certainty and Impact text. So to fill the risk matrix, we will write this formula in cell E5 and copy it to other cells of the matrix. Now the rest of the matrix is filled by this formula= Certainty x Impact The first values assigned to certainty and Impact are arbitrary but in proper ascending order. ![]() In rows, I have assigned the impact and in columns I have written the certainty. You will need to prepare a table like the one below: To use the risk matrix we need to create one first. Let's start this article with the Risk Matrix Example directly without any generic formula. So first we will need to create a risk matrix chart so that we can use it later in our analysis. Impact, possibility or certainty index can be any ascending or descending number. ![]() A risk matrix is used to determine the risk in numbers using the impact and possibility index. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |