Data validation

[Guest]

Can a validation be carried out on a dependent i.e on a function in a cell
e.g =sum(A1..A2), so that it cannot exceed say 100.

Thanks.

 

[Guest]

Can a validation be carried out on a dependent i.e on a function in a cell
e.g =sum(A1..A2), so that it cannot exceed say 100.

Thanks.

Hi

Something like this; =IF(SUM(A1:A2)<=100,SUM(A1:A2),"Must Not Exceed 100")

Regards
Peter

 

[Guest]

Dear Billy

Thanks for your suggestion. What about using the Data validation process
within Excel 2003.

Thanks. NC

 

[Guest]

Hi,

Excel -- Data Validation -- Create Dependent Lists.

Use this URL: http://www.contextures.com/xlDataVal02.html

Challa Prabhu

 

[Guest]

Is your requirement to enter a value in say B1 and that value to be less than
SUM(A1:A2)?

If so,

DV for B1:

Custom==>Formula is: =B1<SUM(A1:A2)

HTH

 

[Guest]

My requirement is to have the function =SUM(A1:A2) in cell say A3 and this
cell cannot be greater than 100. I would prefer to use the data validation
method if possible.

 

[JE McGimpsey]

Select A1 & A2 and use this Validation scheme:

Allow: Custom
Formua: =$A$3<=100