how to display an error message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF, but Not to Exceed 3
help with formula and multiple associated data sets 1
How can I conditionally hide or display data in a cell? 2
Formula, automation turn red if value exceed a number 3
IF Statements 2
How to I set a limit on the value returned by a cell 3
Calculate the number of hours in a date/time cell 1
Adding Times 7

Back
Top