Data validation

N

nc

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.
 
B

Billy Liddel

nc said:
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.
Click to expand...

Hi

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

Regards
Peter
 
N

nc

Dear Billy

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

Thanks. NC
 
T

Toppers

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
 
N

nc

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.
 
J

JE McGimpsey

Select A1 & A2 and use this Validation scheme:

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