| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions | |||
Linear Mode
