SOLVED

# If 3 different cells contain certain values, display value - Formula assistance

Copper Contributor

# 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 one option I need:

IF C18="Y" (AND C10="High") (AND C11="High"), show Action_6 in D18 (have outcomes in a separate sheet, and just put a defined name against each Action_1 through to Action_7).

Another option:

IF C3="Y" (AND C10="Low" OR "Medium") AND C11="Low" OR "Medium"), show Action_4 in D11

Obviously above is not how you would go about writing a formula, but it was just the easiest way I could think of to express what I need to try and achieve.

I also have a much simpler formula in the checklist where choosing a value in just one cell will show an action.

=IFS(C4="Y",Action_1)

Any tips would be much appreciated!

3 Replies
best response confirmed by acopland (Copper Contributor)
Solution

# Re: 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:

=IF(AND(C18="Y", C10="High", C11="High"), "Action_6", "")

=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.

# Re: If 3 different cells contain certain values, display value - Formula assistance

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.

# Re: If 3 different cells contain certain values, display value - Formula assistance

yw
1 best response

Accepted Solutions
best response confirmed by acopland (Copper Contributor)
Solution

# Re: 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: