Jul 21 2021 11:34 PM
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?
Jul 21 2021 11:37 PM
@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?
Jul 21 2021 11:58 PM
Jul 22 2021 12:19 AM
@Sofia2165 Still not very clear. If you have an example workbook that demonstrates what you want to achieve, please upload it.
Jul 22 2021 12:27 AM
Please help me, I'm a little irritated by your request.
You would like to know if A plus B happens take action X, but if A and C instead happens then take action Y '.
What should happen if A plus B and A and C appear at the same time?
Wouldn't it help if only A was searched for a certain value?
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
Jul 22 2021 01:34 AM
Looks like
=IF( (A="Blue")*(B="Yellow"), "Green", IF( (A="Blue")*(B="Red"), "Purple", "Color is not defined"))
Jul 22 2021 02:50 AM
If you want to control values in A, B and C then this would be a simple solution.
Example in the inserted file
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
Jul 22 2021 06:03 AM - edited Jul 22 2021 06:05 AM
@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.
Jul 22 2021 06:24 AM
@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" ?
Jul 22 2021 09:11 PM