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?
Sofia2165 What do you mean by "happens"? IF A and B contain a certain value, or IF A + B add up to a certain value? Or perhaps IF both A and B are not blank/empty?
Hi Riny
A and B are not values nor blank. I'm basically trying to say that if two particular criteria are met (A and B) then the required action should be X. Neither the criteria nor the action is numeric values.
Example:
Blue + Yellow is Green, but Blue + Red is purple.
A and B are not values nor blank. I'm basically trying to say that if two particular criteria are met (A and B) then the required action should be X. Neither the criteria nor the action is numeric values.
Example:
Blue + Yellow is Green, but Blue + Red is purple.
- IF(AND(A=TRUE,B=TRUE), DoThisAction, DoThatAction)
IF(AND(A=5,B=5), x*y, x-y) Looks like
=IF( (A="Blue")*(B="Yellow"), "Green", IF( (A="Blue")*(B="Red"), "Purple", "Color is not defined"))Sofia2165 Still not very clear. If you have an example workbook that demonstrates what you want to achieve, please upload it.
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" ?
