running balance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PR Kid - 13 Mar 2008 21:43 GMT

How can I have the running balance show up as I plug in number without it
showing the balance down the entire colunm if I use =b2+c2+c1 as the formula

=b3+c3+c2 and so on.
ie
A B C
Day Reg hrs OT Running Total hrs
1 10 1 11
2 9 0 20
4 0

Signature

Have a great day

Reply to this Message

Sandy Mann - 13 Mar 2008 22:09 GMT

=IF(COUNT(B3:C3)=2,B3+C3+C2,"")

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> How can I have the running balance show up as I plug in number without it
> showing the balance down the entire colunm if I use =b2+c2+c1 as the
[quoted text clipped - 7 lines]
> 2 9 0 20
> 4 0

Reply to this Message

Sandy Mann - 13 Mar 2008 22:13 GMT

My formula assumed that you will always be entering zero for no OT hours, it
not use:

=IF(Count(B3:C3)>0,B3+C3+C2,"")

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> How can I have the running balance show up as I plug in number without it
> showing the balance down the entire colunm if I use =b2+c2+c1 as the
[quoted text clipped - 7 lines]
> 2 9 0 20
> 4 0

Reply to this Message

Rate this thread: