Require cell entry based on another cell's answer

[melissapalmer]

The last thing I need in my excel spreadsheet is to require a date be input in B6 should the answer in B5 be "yes". The scenario is as follows: B5 can be yes, no or blank. If B5 is no or blank I dont need anything in B6 and the overall answer to all the previous answers will be displayed in B12. However, if B5 is "yes", B6 must have a date before the overall answer can be displayed in B12. Is there a formula to do this? I have tried excel formulas but I believe I may need a visual basic code and I have very little experience with VB. ANy help is GREATLY appreciated!!!!

 

[melissapalmer]

Almost there!
Ok I copied the formula above into B12 but there is no answer coming up in that cell now???

 

[Snakehips]

Here are some example results.

Excel 2007
	B	C	D	E	F	G	H	I
3	Tom Thumb			yes
4	06/07/2012
5	No
6
7
8
9
10
11
12
Sheet1

Cell Formulas
Range	Formula
B12	=IF(AND(B5 = "Yes",(B4)>20000,B6>=B4),IF(COUNTBLANK(B3:B5)>0,"",IF(OR(E3="Yes",G3="Yes",I3="Yes"),"Yes","No")),"")

Excel 2007
	B	C	D	E	F	G	H	I
3	Tom Thumb			yes
4	06/07/2012
5	Yes
6
7
8
9
10
11
12
Sheet1

Excel 2007
	B	C	D	E	F	G	H	I
3	Tom Thumb			Yes
4	06/07/2012
5	Yes
6	06/08/2012
7
8
9
10
11
12	Yes
Sheet1

Excel 2007
	B	C	D	E	F	G	H	I
3	Tom Thumb
4	06/07/2012
5	Yes
6	06/08/2012
7
8
9
10
11
12	No
Sheet1

Excel 2007
	B	C	D	E	F	G	H	I
3
4	06/07/2012
5	Yes
6	06/08/2012
7
8
9
10
11
12
Sheet1

Are these results not what you want?
If not then please explain.

 

[melissapalmer]

Ok, from your screen shots I think I know the issue. Using the first example you provided above - B12 is blank if B5 is no. if B5 is no I still need b12 to provide the overall answer.

B12 needs to be blank until all other questions are answered. B3, B4 and B5 are always needed. B12 will provide an answer once the questions are answered. The issue I think is that B6 is only needed when B5 is yes. If B5 is no or NA then B12's formula will still work to answer based on B3, B4, B5.
The problem I cant get around is how to make it required to have a date in B6 if B5 is yes.
I hope this make sense.

 

[Snakehips]

How about this....

Excel 2007

	B	C	D	E	F	G	H	I
3	Tom Thumb			yes
4	06/07/2012
5	Yes
6	02/02/2013
7
8
9
10
11
12	Yes

<COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
</TBODY>

Sheet1​

Worksheet Formulas Cell Formula B12 =IF(B5="Yes",IF(B6<20000,"Need Contract Date",IF(COUNTBLANK(B3:B5)>0,"",IF(OR(E3="Yes",G3="Yes",I3="Yes"),"Yes","No"))),IF(COUNTBLANK(B3:B5)>0,"",IF(OR(E3="Yes",G3="Yes",I3="Yes"),"Yes","No"))) <THEAD> </THEAD><TBODY> </TBODY>

<TBODY>
</TBODY>

Excel 2007
	B	C	D	E	F	G	H	I
3	Tom Thumb			yes
4	06/07/2012
5	Yes
6
7
8
9
10
11
12	Need Contract Date
Sheet1

Fingers crossed!!!

 

[melissapalmer]

Snakehips:
It looks like it is working for you but it isnt working in my worksheet. Grrrr!
The only thing that would be different possibly is I could have "yes" in either E1, G1, or I1 - it is based on hidden cells and dates the user inputs - but they could be "false" too. In most instances where B5 is "yes" and B6 is blank, E1, G1, and I1 are all "False".

If I change B5 to "yes" and B6 is blank then B12 still says "No".
Below is exactly what I am wanting to happen though with B12 saying Need date.

Excel 2007

	B	C	D	E	F	G	H	I
3	Tom Thumb			yes
4	06/07/2012
5	Yes
6
7
8
9
10
11
12	Need Contract Date

<COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
</TBODY>

Sheet1​

 

[Deborah Cathey]

I am trying to do something similar, I tried to adjust the code, but obviously it didn't work. If H29 = Yes, then I require text to be entered into I29. Another question, when would the required entry be populated to the data entry person?