| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function in Data Validation- XL03
I want to make a cell only validate an entry if another cell equals a value.
I'm using DATAVALIDATION and selecting CUSTOM. This is my formula: =IF(NOT(C5="R"),"X","") I want this cell to recognize if Cell C5 contains ONLY the letter "R" it is to accept ONLY the letter "X" as an entry. If cell C5 doesn't contain ONLY the letter "R" it is to accept ANY entry. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I auto-alphabatize in XL03? | Excel Discussion (Misc queries) | |||
| Validating a name without using the Data Validation function | Excel Worksheet Functions | |||
| data validation - indirect function | Excel Discussion (Misc queries) | |||
| data validation with EOMONTH function | Excel Worksheet Functions | |||
| Data Validation Function Help | Excel Worksheet Functions | |||
Threaded Mode
