Data Validation

[Guest]

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

 

[Guest]

Try the data validation formula

=a1>SUM(a2:a14)

Mike

 

[Guest]

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.

 

[Guest]

I misunderstood, try:-

=A1>MIN(A2:A14)

Mike

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.

 

[Guest]

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"

 

[Guest]

Ollie

Data|validation|Custom

Enter the formula. Also I may have the > sign the wrong way around to
achieve what you want.

Mike

 

[Guest]

Hi Mike,

I have now got it working OK. Very very much appreciated.
Thank you very much for you help and patience.
Regards
Ollie