I am filling out a list of capabilities that have sub-capabilities.
A2 is the Capabilty Name
A3 is the Sub-Capability name
B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A"
In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a drop down list (Yes, No, or N/A)to select from for B3 or if it is not Yes then leave the cell blank.
[TABLE="width: 248"]
<tbody>[TR]
[TD][/TD]
[TD]B2[/TD]
[TD]B3[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]Capability[/TD]
[TD]Yes/No[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Voice[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Voice Skills Based Routing[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]IVR[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD]IVR Call Routing[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD]IVR Skills Based routing[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD]Automated Surveys[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD]Surveys (IVR)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A9[/TD]
[TD]Surveys (Web/email/text)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I would think the IF statement would look something like this but I am not sure what the syntax is to have it present a drop down list:
=IF( A2="Yes", drop down list,IF(A2="No", "", IF(A2="N/A", "","")))
A2 is the Capabilty Name
A3 is the Sub-Capability name
B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A"
In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a drop down list (Yes, No, or N/A)to select from for B3 or if it is not Yes then leave the cell blank.
[TABLE="width: 248"]
<tbody>[TR]
[TD][/TD]
[TD]B2[/TD]
[TD]B3[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]Capability[/TD]
[TD]Yes/No[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Voice[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Voice Skills Based Routing[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]IVR[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD]IVR Call Routing[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD]IVR Skills Based routing[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD]Automated Surveys[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD]Surveys (IVR)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A9[/TD]
[TD]Surveys (Web/email/text)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I would think the IF statement would look something like this but I am not sure what the syntax is to have it present a drop down list:
=IF( A2="Yes", drop down list,IF(A2="No", "", IF(A2="N/A", "","")))