Forum Discussion
IF Statement and Data Validation List
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 ...
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?