IF Statement and Data Validation List

Copper Contributor

I have Data Validation lists in multiple columns on a spreadsheet.  The Data Validation lists includes Yes, No, N/A, or a blank cell.  I inserted an IF statement for the following:

1) If the answer to Question #1 is Yes, then I would like the cells for Question #2 through #4 to remain blank.

2) If the answer to Question #1 is No, then I would like the cells for Question #2 through #4 to display N/A. 

 

I figured out point 2 mentioned above but I cannot figure out point 1.  When I try to include "" in the IF statement for when the statement is false, I receive the below error message.

 

JillM2449_0-1699985516559.png

 

JillM2449_1-1699985681975.png

 

 

1 Reply

@JillM2449 

If you enter a formula in column B, that formula will be overwritten when the user selects an entry from the drop-down list. Is that really what you want?