| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Help
I am trying to set a data validation to respond this way:
If A1="Add", then value must be =0. If A1="Drop", then value must be <=0. If A1=(Any Other Value), then accept any value. Here is the formula in the data validation that I am using now. It does everything except allow any value if A1 is not Add or Drop. =IF(B14="Drop",E14<=0,IF(B14="Add",E14=0,"")) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Help
Try this:
Formula: =IF(B14="Drop",E14<=0,IF(B14="Add",E14=0,TRUE)) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Josh O." wrote: I am trying to set a data validation to respond this way: If A1="Add", then value must be =0. If A1="Drop", then value must be <=0. If A1=(Any Other Value), then accept any value. Here is the formula in the data validation that I am using now. It does everything except allow any value if A1 is not Add or Drop. =IF(B14="Drop",E14<=0,IF(B14="Add",E14=0,"")) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Help
Perfect...thank you.
"Ron Coderre" wrote: Try this: Formula: =IF(B14="Drop",E14<=0,IF(B14="Add",E14=0,TRUE)) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Josh O." wrote: I am trying to set a data validation to respond this way: If A1="Add", then value must be =0. If A1="Drop", then value must be <=0. If A1=(Any Other Value), then accept any value. Here is the formula in the data validation that I am using now. It does everything except allow any value if A1 is not Add or Drop. =IF(B14="Drop",E14<=0,IF(B14="Add",E14=0,"")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Data Validation | Excel Worksheet Functions | |||
| data validation lists | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
