jprimalion
New Member
- Joined
- Nov 10, 2014
- Messages
- 3
Hi there, I've already tried researching and experimenting on different ways to fix the problem that I have with my workbook. I am trying to nest together multiple IF AND formulas together.
<tbody>
</tbody>
So, in this example, let's say:
IF "Team Name"/A2 = "Green" and "Sense 1"/C2 = "Yes", Then "Dex Code" / B2 = "GreenYes", ELSE "Dex Code" / B2 = "GreenNo".
IF "Team Name"/A2 = "Blue" and "Sense 1"/C2 = "Yes", Then "Dex Code" / B2 = "BlueYes", ELSE "Dex Code" / B2 = "BlueNo".
etc.
So basically what I am trying to achieve is to have one formula that the selections will validate all of them in just one cell.
Can anyone help?
Thanks in advance!
Scenario:
A | B | C | |
1 | Team Name | Dex Code | Sense 1 |
2 | Green | GreenYes | Yes |
3 | Green | GreenNo | No |
4 | Blue | BlueYes | Yes |
5 | Blue | BlueNo | No |
6 | Orange | OrangeYes | Yes |
<tbody>
</tbody>
So, in this example, let's say:
IF "Team Name"/A2 = "Green" and "Sense 1"/C2 = "Yes", Then "Dex Code" / B2 = "GreenYes", ELSE "Dex Code" / B2 = "GreenNo".
IF "Team Name"/A2 = "Blue" and "Sense 1"/C2 = "Yes", Then "Dex Code" / B2 = "BlueYes", ELSE "Dex Code" / B2 = "BlueNo".
etc.
So basically what I am trying to achieve is to have one formula that the selections will validate all of them in just one cell.
Can anyone help?
Thanks in advance!