Data Validation Help

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

[Ron Coderre]

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

[Josh O.]

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