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.

"nc" wrote:

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

Dear Billy

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

Thanks. NC

"Billy Liddel" wrote:



"nc" wrote:

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

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

"nc" wrote:

Dear Billy

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

Thanks. NC

"Billy Liddel" wrote:



"nc" wrote:

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

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.



"Toppers" wrote:

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

"nc" wrote:

Dear Billy

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

Thanks. NC

"Billy Liddel" wrote:



"nc" wrote:

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

Select A1 & A2 and use this Validation scheme:

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


In article ,
nc wrote:

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.

Hi,

Excel -- Data Validation -- Create Dependent Lists.

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

Challa Prabhu

"nc" wrote:

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.