Forum Discussion
Solved
If 3 different cells contain certain values, display value - Formula assistance
Hi, it's me, someone bad at formulas. I'm trying to do a checklist/form in Excel. I want to try and show proposed outcomes based on the responses to criteria in the checklist. Example of on...
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.