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!
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!