"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