Data Validation Help

J

Josh O.

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

Ron Coderre

Try this:

Formula: =IF(B14="Drop",E14<=0,IF(B14="Add",E14>=0,TRUE))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
J

Josh O.

Perfect...thank you.

Ron Coderre said:
Try this:

Formula: =IF(B14="Drop",E14<=0,IF(B14="Add",E14>=0,TRUE))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 
Top