Formula for Data Validation

[Nadine]

My formula reads:
=AND(V11<=$L11,V11<=$J11)

Col V is where the payment is entered.
Col L is how much has been invoiced.
Col J is how much has been approved for payment.

The amount paid should not exceed either of the amount invoiced or the
amount approved.

Can someone help? When entering a split payment, meaning the payment amount
is entered in col V and in col Z, the formula will not let you enter an
amount in col Z even if the total is still less than either of the amounts in
cols L & J. This is with Excel 2003.

Thanks so much.

Nadine

 

[JLGWhiz]

The amount entered in column Z is irrelevant. The criteirea is based on
whether the formula is true or false and that involves the values int V11,
J11 and L11. If the formula equates to True you can put any amount you want
into the cell containing the validation criteria. If it is False, you can't
put anything in that cell.