How do I make Cell B21 = I1 or I2 or I3 or I4 depending on conditions of other cells

[legolas97]

How do I make Cell B21 = I1 or I2 or I3 or I4 depending on conditions of other cells

If B11 and B15 = Yes, I need B23 to =I1

if B11 = Yes and B15 = No, I need B23 to =I2

If B11 = No and B15 = Yes, I need B23 to =I3

So on. If someone can give me an idea of how to code this, I can attempt to do so! Any help is much appreciated!

 

[Joe4]

Try this formula in cell B23:

=IF(AND(B11="Yes",B15="Yes"),I1,IF(AND(B11="Yes",B15="No"),I2,IF(AND(B11="No",B15="Yes"),I3,IF(AND(B11="No",B15="No"),I4,""))))

 

[legolas97]

Try this formula in cell B23:

=IF(AND(B11="Yes",B15="Yes"),I1,IF(AND(B11="Yes",B15="No"),I2,IF(AND(B11="No",B15="Yes"),I3,IF(AND(B11="No",B15="No"),I4,""))))

Thanks a bunch you genius! hehe

 

[Joe4]

You are welcome.

Note that what I used is known as a "Nested If" formula.
To see a good explanation of how those work, see this link: Excel Nested IF statements - examples, best practices and alternatives - Ablebits.com