data validation

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

I would like to know if it is possible to use data validation on a
field that is summing/totalling data. IE total 1+2+3=6. is it
possible in the total field to use data validation so if the total is
not equal to 6 then error?

I have tried this by establishing sum field totalling a1...a5 in A6
field, but when I go into input data into a1..a5 and it totals the
data validation on A6 doesn't provide an error message?

Any help is greatly appreciated
 
I would like to know if it is possible to use data validation on a
field that is summing/totalling data. IE total 1+2+3=6. is it
possible in the total field to use data validation so if the total is
not equal to 6 then error?

I have tried this by establishing sum field totalling a1...a5 in A6
field, but when I go into input data into a1..a5 and it totals the
data validation on A6 doesn't provide an error message?

Any help is greatly appreciated
Click to expand...

By the way I am using Excel 2003 as the application
 
suggest you post to an Excel newsgroup, then. this ng answers questions
about MS Access relational database software.
 

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 9
Aggregate Function Error 0
Average Question 2
Copy a formula using Vlookup 2
Formula Question 2
Copy/Fill increments 8
Require Password to overide data validation 1
If formula and Data Validation parallely 1

Back
Top