| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function in Data Validation- XL03
You need a formula that returns TRUE when either C5 is not R or the given
cell is set to X. If this is to apply to A1, then the custom validation formula would be =or(C5<"R",A1="X") "Conker10382" wrote: 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. |
| Reply |
| 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 | |||
Hybrid Mode
