and i added my constant row value which is the Site Severity ($B$3)!
I've changed the variables to "H"=high,"M"=Medium,"L"=Low.
For some reason though the formula does not see the entry for "L" nor in the first part or in the second part of the formula. If I enter the letter "G" it produces error. If I enter the letter "L" it gives wrong result ....
In the example above
L+M+3 should be equal to 4 but it returns the result 6!
H = 2
M = 1
L = 0
Again i really appreciated your feedback.
The aim is to calculate the risk value for a building according to ISO 27005. The above calculation is based on a standard matrix.
You were right....It worked!!!! I really thank you support but mostly for your prompt response. These tables will help me in the organization to give them to department managers to help us with this ongoing project.
Your solution was spot on. Thank you again.
I really thank you for your reply but the formula does not work 100%. It seems that it doesn't read one of the variables.
See explanation below
SITE Severity 3 (Cell B3)
Prop vuln
L M
Risk / Threat 4
Your formula:
LOOKUP(C3, {"H","M","L"}, {2,1,0}) + LOOKUP(D3, {"H","M","L"}, {2,1,0})+($B$3)
and i added my constant row value which is the Site Severity ($B$3)!
I've changed the variables to "H"=high,"M"=Medium,"L"=Low.
For some reason though the formula does not see the entry for "L" nor in the first part or in the second part of the formula. If I enter the letter "G" it produces error. If I enter the letter "L" it gives wrong result ....
In the example above
L+M+3 should be equal to 4 but it returns the result 6!
H = 2
M = 1
L = 0
Again i really appreciated your feedback.
The aim is to calculate the risk value for a building according to ISO 27005. The above calculation is based on a standard matrix.
Regards
Christoss