#VALUE# error with Data Validation

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

Guest

Cells B10:K10 contain sales data. Cells B20:K30 display the percentage of
Product A included in cells B10:K10.

To reduce clutter in B20:k30, I added data validation that only permits
entries if the corresponding row in B10:k10 contains numbers greater than
zero. The problem is that cells B20:K30 are used in subsequent
multiplications and, if they are left unpopulated as a result of data
validation restrictions, I end up with a bunch of #VALUE# errors. Is there a
work-around?
 
KG said:
Cells B10:K10 contain sales data. Cells B20:K30 display the percentage of
Product A included in cells B10:K10.

To reduce clutter in B20:k30, I added data validation that only permits
entries if the corresponding row in B10:k10 contains numbers greater than
zero. The problem is that cells B20:K30 are used in subsequent
multiplications and, if they are left unpopulated as a result of data
validation restrictions, I end up with a bunch of #VALUE# errors. Is there a
work-around?
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

Summing a Column wit errors? 4
VBA error: "object doesn't support this property or method" 2
Data Validation - Complex Q 2
Data validation- absolute ref or not- neither works 3
data validation rule 4
Automatically adding cells with values 3
pull data from multiple sheets with formula referencing a tab name 5
I hate the DIV/0! error! Can anyone help me make this go away? 5

Back
Top