Data Validation

  • Thread starter Thread starter Esrei
  • Start date Start date
E

Esrei

The value in D8 is not a formula if I use <> (not equal
to) in a data validation custom formula it does not work
when I change the value but if I only use < or > it works
why
In other works if the formula is D8<1.5 and I change the
value to 1 it error message apears but if the formula is
D8<>1.5 no matter how I change the value no error apears
Thankx
 
In which cell are you using this data validation?
The value in D8 is not a formula if I use <> (not equal
to) in a data validation custom formula it does not work
when I change the value but if I only use < or > it works
why
In other works if the formula is D8<1.5 and I change the
value to 1 it error message apears but if the formula is
D8<>1.5 no matter how I change the value no error apears
Thankx
Click to expand...
 
You must log in or register to reply here.

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

Data Validation 1
If/Then Formula Using Dates 1
#VALUE! Error 3
CREATE FORMULA IN EXCEL 2
Seeding in Drop Down List 3
formula help 4
Exceed 7 nested formula's (apparently) 2
If then on drop down 1

Back
Top