Post

2 followers Follow
0
Avatar

Error occured kindly validate the formula

Risk Rate have to automatically calculated based on combination as listed below 

  • Critical – High impact / High Probability
  • High – High impact / Low Probability
  • Medium - Low impact/high probability
  • Low - Low impact/low probability

Kindly let me know the whether this is correct or not?

$RiskRate = If(($C_RiskImpact = "HIGH")&&($C_RiskProbability = "LOW"),"HIGH",If(($C_RiskImpact = "HIGH")&&($C_RiskProbability = "HIGH"),"CRITICAL",If(($C_RiskImpact = "LOW")&&($C_RiskProbability = "HIGH"),"MEDIUM",If(($C_RiskImpact = "LOW")&&($C_RiskProbability = "LOW"),"LOW"))))

Nivashkumar K Answered

Please sign in to leave a comment.

2 comments

0
Avatar

Hi Josh Santos,

It is not working , throwing error as Error: Function If() expects exactly 3 arguments

Kindly help me with sharing the correct formula, which results in returning the expected value, with no syntax error. 

Nivashkumar K 0 votes
Comment actions Permalink