I have tried this formula but it does not work for me. Perhaps I am choosing
the incorrect drop down in the "Data" box. I am choosing Allow whole number.
Which one should I choose in the "Data "box. I tried "equals too"

"Mike H" wrote:

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