Help with simple (I think) spreadsheet Please?!

[jtees4]

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.

 

[keithl816]

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

 

[jtees4]

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.

 

[keithl816]

Hi Jeets4,

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

Larry