Help Please! I am trying to populate column F based of the information in columns A-E. The cells I have labeled as Yes/No will initially be blank and will have a data validation to be either Yes or No.
An ideas are most appreciated!
<tbody>
</tbody>
An ideas are most appreciated!
A | B | C | D | E | F | |||
1 | Build | Yes/No | Yes/No | Yes/No | Yes/No | |||
2 | Test | Yes/No | Yes/No | Yes/No | Yes/No | |||
3 | Yes/No | Yes/No | Yes/No | Yes/No | ||||
4 | Write | Yes/No | Yes/No | Yes/No | Yes/No | |||
5 | Ship | Yes/No | Yes/No | Yes/No | Yes/No | |||
Use data in columns A-E and place result in column F | ||||||||
If A is missing, Leave F blank | ||||||||
If A is populated and B is "No", then place the text "Stop Here" in column F | ||||||||
If A is populated and B is "Yes" and C, D & E are "Yes", then place the text "Obligation" in column F | ||||||||
If A is populated and B is "Yes" any of C, D & E are "No", then place the text "Not anObligation" in column F | ||||||||
<tbody>
</tbody>