Prev: Send a worksheet to an open email
Next: testing for password protection
From: Nadine on 27 May 2010 16:42
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
From: JLGWhiz on 27 May 2010 18:57
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.



"Nadine" <Nadine(a)discussions.microsoft.com> wrote in message
news:7A394907-4625-4EC9-B231-A2BE52E216E0(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: Send a worksheet to an open email
Next: testing for password protection