Thread
:
running balance
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann