Data Validation Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,""))
 
Try this:

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

Does that help?

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

XL2002, WinXP-Pro
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if function help 5
Overtime Calculations 1
Excel Need Countifs Formula Help 0
Help with time conversions 4
Data Validation w/an If Statement 1
Need to test for alphanumeric value and write numeric values to ce 3
A data validation question 1
Same formula returns different results 1

Back
Top