running balance
 

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
--
Have a great day

running balance
 

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

--
HTH

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


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


"PR Kid" wrote in message
...
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
--
Have a great day

running balance
 

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,"")

--
HTH

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


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


"PR Kid" wrote in message
...
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
--
Have a great day