Data Validation
 

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

Data Validation
 

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

Data Validation
 

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

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

Data Validation
 

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

Data Validation
 

Ollie

Data|validation|Custom

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

Mike

"ollie" wrote:

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

Data Validation
 

Hi Mike,

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

"Mike H" wrote:

Ollie

Data|validation|Custom

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

Mike

"ollie" wrote:

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