I am still do not see where the overpayment is taken into account (the
balance of -100), or the 'discount' given of 72.

Is there a way you could post the file (there are many free file hosters out
there, I just don't have a name of one). A sample file anyway...

Thanks.
--
John C


"Julie" wrote:

I need to make a formula that if any item in column E is equal to any of the
items in column A then the quantity in column F(beside the item in E) needs
multiplied by the set price in column B(beside the item in A) example:

our set price list forecast sent to us
A B E F
15354792 .056 15418001 2000
15418001 .032 12129811 5000
12034476 .011