Hi. I am trying to do this for work and can't seem to get it.
I hope my example makes some sense and thank you all in advance for
any help you may be able to give me.


COLUMNS
A=DATE (weekending date)
B=HOURS WORKED THAT WEEK
C=AMOUNT DUE (Pay rate in column J X COLUMN B)
D=AMOUNT PAID (Of the total weekly amount due)
E=AMOUNT OWED (Amount owed for the week)
F=BLANK
G=PAYMENT DATE
H=PAYMENT AMOUNT (payments are made whenever for various amounts)
J=PAY RATE per hour

Each week I fill in hours worked that week. It will automatically
calculate what is owed based on B X J. Payments are made whenever cash
is available, payments do not necessarily exactly match amounts owed.
When I imput an amount paid in column H, I need columns D and E to
calculate automatically.

If anyone needs specific information I can send an Excel file to
anyone interested in helping. It's simple I know...but I have hit a
roadblock for some reason. Thank you all.

Hi jtees4,

You can put a formula similar to this in C2: =sum(b2*j2) This would
give you the amount due in Cell C2.

Will this help?

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=487828

On Wed, 23 Nov 2005 20:40:54 -0600, keithl816
wrote:


Hi jtees4,

You can put a formula similar to this in C2: =sum(b2*j2) This would
give you the amount due in Cell C2.

Will this help?

Larry

Thanks for the reply. I'm not sure if that will help or not, but I
will check when I get a minute. If you are good at this stuff I can
email you the file because my description really does not reflect
exactly as it is. Let me know. Thanks again.

Hi Jeets4,

PM me your e-mail address and I'll reply back with mine.

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=487828