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!
[TABLE="width: 515"]
<tbody>[TR]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"]A
[/TD]
[TD="width: 81, bgcolor: transparent"]B
[/TD]
[TD="width: 81, bgcolor: transparent"]C
[/TD]
[TD="width: 81, bgcolor: transparent"]D
[/TD]
[TD="width: 81, bgcolor: transparent"]E
[/TD]
[TD="width: 145, bgcolor: transparent"]F
[/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"]1
[/TD]
[TD="width: 145, bgcolor: transparent"]Build
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"]2
[/TD]
[TD="width: 145, bgcolor: transparent"]Test
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"]3
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"]4
[/TD]
[TD="width: 145, bgcolor: transparent"]Write
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"]5
[/TD]
[TD="width: 145, bgcolor: transparent"]Ship
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 470, bgcolor: transparent, colspan: 5"]Use data in columns A-E and place result in column F
[/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 226, bgcolor: transparent, colspan: 2"]If A is missing, Leave F blank
[/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 696, bgcolor: transparent, colspan: 7"]If A is populated and B is "No", then place the text "Stop Here" in column F
[/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 777, bgcolor: transparent, colspan: 8"]If A is populated and B is "Yes" and C, D & E are "Yes", then place the text "Obligation" in column F
[/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 859, bgcolor: transparent, colspan: 9"]If A is populated and B is "Yes" any of C, D & E are "No", then place the text "Not anObligation" in column F
[/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
An ideas are most appreciated!
[TABLE="width: 515"]
<tbody>[TR]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"]A
[/TD]
[TD="width: 81, bgcolor: transparent"]B
[/TD]
[TD="width: 81, bgcolor: transparent"]C
[/TD]
[TD="width: 81, bgcolor: transparent"]D
[/TD]
[TD="width: 81, bgcolor: transparent"]E
[/TD]
[TD="width: 145, bgcolor: transparent"]F
[/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"]1
[/TD]
[TD="width: 145, bgcolor: transparent"]Build
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"]2
[/TD]
[TD="width: 145, bgcolor: transparent"]Test
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"]3
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"]4
[/TD]
[TD="width: 145, bgcolor: transparent"]Write
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"]5
[/TD]
[TD="width: 145, bgcolor: transparent"]Ship
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 81, bgcolor: transparent"]Yes/No
[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 470, bgcolor: transparent, colspan: 5"]Use data in columns A-E and place result in column F
[/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 226, bgcolor: transparent, colspan: 2"]If A is missing, Leave F blank
[/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 696, bgcolor: transparent, colspan: 7"]If A is populated and B is "No", then place the text "Stop Here" in column F
[/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 777, bgcolor: transparent, colspan: 8"]If A is populated and B is "Yes" and C, D & E are "Yes", then place the text "Obligation" in column F
[/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 859, bgcolor: transparent, colspan: 9"]If A is populated and B is "Yes" any of C, D & E are "No", then place the text "Not anObligation" in column F
[/TD]
[/TR]
[TR]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]