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,""))
|