software

I am trying to set a data validation to respond this way:
If A1=quot;Addquot;, then value must be gt;=0.
If A1=quot;Dropquot;, then value must be lt;=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=quot;Dropquot;,E14lt;=0,IF(B14=quot;Addquot;,E14gt;=0,quot;quot;))

Try this:

Formula: =IF(B14=quot;Dropquot;,E14lt;=0,IF(B14=quot;Addquot;,E14gt;=0,TRUE))

Does that help?

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

XL2002, WinXP-Proquot;Josh O.quot; wrote:

gt; I am trying to set a data validation to respond this way:
gt; If A1=quot;Addquot;, then value must be gt;=0.
gt; If A1=quot;Dropquot;, then value must be lt;=0.
gt; If A1=(Any Other Value), then accept any value.
gt;
gt; Here is the formula in the data validation that I am using now. It does
gt; everything except allow any value if A1 is not Add or Drop.
gt; =IF(B14=quot;Dropquot;,E14lt;=0,IF(B14=quot;Addquot;,E14gt;=0,quot;quot;))

Perfect...thank you.

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Formula: =IF(B14=quot;Dropquot;,E14lt;=0,IF(B14=quot;Addquot;,E14gt;=0,TRUE))
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Josh O.quot; wrote:
gt;
gt; gt; I am trying to set a data validation to respond this way:
gt; gt; If A1=quot;Addquot;, then value must be gt;=0.
gt; gt; If A1=quot;Dropquot;, then value must be lt;=0.
gt; gt; If A1=(Any Other Value), then accept any value.
gt; gt;
gt; gt; Here is the formula in the data validation that I am using now. It does
gt; gt; everything except allow any value if A1 is not Add or Drop.
gt; gt; =IF(B14=quot;Dropquot;,E14lt;=0,IF(B14=quot;Addquot;,E14gt;=0,quot;quot;))