Excel 2003 Tally an IOU column for customers

[adulted]

Hello all,

I am trying to get a no result or the money owed for purchase in column K, The formula I am using returns False if Paid.

Row 8 shows in Column K 12.00 owing as the purchase or Cash was not submitted in Column G, was not paid.

Thank you in advanced.
Paul

Excel 2003
	A	B	C	D	E	F	G	H	I	J	K
5	CustNo	BrandNo	Date	Name	Brand	Drinks	Cash	Total	Change	Cost	IOU
6	1	1	Mon Sep 12, 2016	DotCom	Coors Light	3	$ 20.00	9.00	$ 14.00	$ 3.00	FALSE
7	5	2	Mon Sep 12, 2016	Jim R	Laker Lager	2	$ 15.00	6.00	$ 10.00	$ 3.00	FALSE
8	2	1	Mon Sep 12, 2016	Wayne	Coors Light	4		12.00		$ 3.00	$ 12.00
Sheet1

Cell Formulas
Range	Formula
C6	=IF(A6="","",TODAY())
C7	=IF(A7="","",TODAY())
C8	=IF(A8="","",TODAY())
D6	=IF(A6="","",VLOOKUP(A6,Customer,2))
D7	=IF(A7="","",VLOOKUP(A7,Customer,2))
D8	=IF(A8="","",VLOOKUP(A8,Customer,2))
E6	=IF(B6="","",VLOOKUP(B6,Brand,2))
E7	=IF(B7="","",VLOOKUP(B7,Brand,2))
E8	=IF(B8="","",VLOOKUP(B8,Brand,2))
H6	=IF(F6="","",F6*J6)
H7	=IF(F7="","",F7*J7)
H8	=IF(F8="","",F8*J8)
I6	=IF(G6="","",G6-F6-J6)
I7	=IF(G7="","",G7-F7-J7)
I8	=IF(G8="","",G8-F8-J8)
J6	=IF(B6="","",VLOOKUP(B6,$M$6:$R$9,6))
J7	=IF(B7="","",VLOOKUP(B7,$M$6:$R$9,6))
J8	=IF(B8="","",VLOOKUP(B8,$M$6:$R$9,6))
K6	=IF(G6="",F6*J6)
K7	=IF(G7="",F7*J7)
K8	=IF(G8="",F8*J8)

Named Ranges
Name	Refers To	Cells
Brand	=Sheet1!$M$6:$R$9
Customer	=Sheet1!$M$15:$N$34

 

[Jeffrey Mahoney]

You didn't finish the IF statement
=IF(G6="",F6*J6,0)

But what if they don't pay all their bill. How about
=max(F6*J6-G6,0)
This way it will calculate zero if the bill is payed or any amount from the total bill to the total bill less a partial payment.

Jeff