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.

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.

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.

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.