Forum Discussion
If functions
Looking for a formula that can say 'if A plus B happens take action X, but if A and C instead happens then take action Y'. Is that possible in Excel?
Riny_van_Eekelen
What i'm trying to do is a form of risk assessment/analysis. But rather than a matrix, I was looking to have input fields (likely from a drop-down) for risk and likelyhood and then a show the consequence and severity if it were to happen.
Sofia2165 Sorry for being slow, but can you explain how the matrix relates to your very first post "if A plus B happens take action X" ?