Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a spreadsheet with Data Validation in Column M showing List A through H. Example: Cell M3 can either be null or have value A, B, C etc thru H I need to validate in Cell O3, based upon what they did in cell M3. Here's an example: If M3 is null, then O3 can either be zero (0) or can have value with min = .01 and max = .04. User is not allowed to enter anything 0 and <.01, but we want to allow them to enter 0. If M3 is not null (user selected from list A thru H), then min = 0 and max = 0. Thanks for any help. I've tried a variety of statements with IF/OR and nothing has worked so far. Thanks for any assistance, Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Individual Validation for multiple values in single cell | Excel Worksheet Functions | |||
Help for multiple & variable validation function | Excel Worksheet Functions | |||
Data Validation with Changing Values | Excel Discussion (Misc queries) | |||
Data Validation - combination of values | Excel Discussion (Misc queries) | |||
Data Validation - but not restricting values | Excel Discussion (Misc queries) |