Thread: Data Validation
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Data Validation

I misunderstood, try:-

=A1MIN(A2:A14)

Mike

"ollie" wrote:


Hello Mike
Thanks for your answer.
What I am looking for may not be possible.
My explanation may not have been very explicit.
The value in a1 must not exceed any one of the values in cells a2 to a14.

"Mike H" wrote:

Try the data validation formula

=a1SUM(a2:a14)

Mike

"ollie" wrote:

I want to create a data validation formula that will allow me to input an
amount into a1 cell only if it is greater than the values in cells a2 to a14
. If there are no values in a2 to a14 I also wish to allow the value in a1 to
be input