That looks right to me. Is it working for you?
Comment actions
Post
Follow
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"))))
Please sign in to leave a comment.
2 comments
Date
Votes
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.
Comment actions