| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation formula in cell and list?
Good morning. I'd like to have formula in B2 that returns NA if B1 is No, if
B1 is Yes, i'd like to force drop down selection or validation in B2 of Yes/No - is this possible? A B 1 Was it cold enough to snow? Yes/No 2 Did it snow? =if(B1="No",NA) -- Thank you -- Suzanne. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Formula and Data Validation List in a Single Cell | Excel Worksheet Functions | |||
| Combine Formula and Data Validation List in a Single Cell ?? | Excel Worksheet Functions | |||
| FORMULA WITH A CELL THAT HAS A DATA VALIDATION LIST IN IT | Excel Worksheet Functions | |||
| Deleting formula in data validation list | Excel Worksheet Functions | |||
| HELP: Data > Validation ---List ----Formula | Excel Worksheet Functions | |||
Threaded Mode
