Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is it possible to set up data validation to allow only numbers greater than
or equal to zero OR text equal to n/a. I have check sheets for machine maintenance with specific tests listed and cells formatted to accept results. These results are numeric (=0) but there are some machines without certain options fitted so some checks are not relevant. I would like to allow the user to enter n/a in these cells if the check is not required. Any ideas? -- Ian -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Usage of Data Validation with If Condition | Excel Worksheet Functions | |||
Multiple Data Validation | Excel Discussion (Misc queries) | |||
multiple data validation | Excel Discussion (Misc queries) | |||
if condition with data validation list | Excel Worksheet Functions | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions |