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 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", "")