Help with simple (I think) spreadsheet Please?!
 

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.

Help with simple (I think) spreadsheet Please?!
 

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

Help with simple (I think) spreadsheet Please?!
 

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.

Help with simple (I think) spreadsheet Please?!
 

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