| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
I am looking for a formula to place in Data Validation / Custom so that an
amount cannot be placed in cell a2 unless a1 has a value in it and the value in a2 must not exceed the value in cell a1. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation
Use this formula:
=AND(A1<"",A2<A1) Make sure that the option for "Ignore Blank" is unchecked. "ollie" wrote: I am looking for a formula to place in Data Validation / Custom so that an amount cannot be placed in cell a2 unless a1 has a value in it and the value in a2 must not exceed the value in cell a1. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation
Minor correction:
=AND(A1<"",A2<=A1) This will allow A2 to be equal to or less than A1, but not exceed. "ollie" wrote: I am looking for a formula to place in Data Validation / Custom so that an amount cannot be placed in cell a2 unless a1 has a value in it and the value in a2 must not exceed the value in cell a1. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation
Hello Dom
I have tried the formula and it works great. What would this world do without people like you Thanks a lot Regards Ollie "Dom_Ciccone" wrote: Minor correction: =AND(A1<"",A2<=A1) This will allow A2 to be equal to or less than A1, but not exceed. "ollie" wrote: I am looking for a formula to place in Data Validation / Custom so that an amount cannot be placed in cell a2 unless a1 has a value in it and the value in a2 must not exceed the value in cell a1. |
| 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) | |||
| Refresh existing data when changed in data validation list | New Users to Excel | |||
Linear Mode
