Forum Discussion
If 3 different cells contain certain values, display value - Formula assistance
You can achieve this by using nested IF statements and logical operators in Excel. Your examples can be translated into Excel formulas like this:
For your first example:
=IF(AND(C18="Y", C10="High", C11="High"), "Action_6", "")
For your second example:
=IF(AND(C3="Y", OR(C10="Low", C10="Medium"), OR(C11="Low", C11="Medium")), "Action_4", "")
You can place these formulas in the cells where you want the action names to appear based on the criteria in your checklist.
You can achieve this by using nested IF statements and logical operators in Excel. Your examples can be translated into Excel formulas like this:
For your first example:
=IF(AND(C18="Y", C10="High", C11="High"), "Action_6", "")
For your second example:
=IF(AND(C3="Y", OR(C10="Low", C10="Medium"), OR(C11="Low", C11="Medium")), "Action_4", "")
You can place these formulas in the cells where you want the action names to appear based on the criteria in your checklist.
- You have just saved me so much time and frustration. Thanks Nikolino, I really appreciate it. One day I'll get better at nesting formulas.
