how to display an error message

L

Luzzan

How can i display an error message if the sum of values exceeds a certain
number, or not to allow sellecting a number from a list if the total values
exceeds a certain number
 
B

Bob Phillips

=IF(SUM(A1:A10)>100,"Error",SUM(A1:A10))

What exactly do you mean by selecting from the list? If you mean that you
use that list in Data Validation, you could use a List type with a formula
of =IF(SUM(A1:A10)<=100,A1:A10). One thing to note, if you try to add that
formula to a List type, you get an error, so first set the type to Custom
and add the formula, then OK out. Then go back and change it to List.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top