| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running balance!!!...? | Excel Worksheet Functions | |||
| to keep a running balance | Excel Discussion (Misc queries) | |||
| rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
| How do i set up a running balance on one row? | Excel Worksheet Functions | |||
| running balance | New Users to Excel | |||
Linear Mode
