Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Worksheet
How do I get the formula, that will allow my spreadsheet to work like a bankbook. to subtract and add the debits and credits and give me the balance in another colume.
EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Worksheet
Mike,
there are hundreds of templates available to do this. have a looke here for a start http://office.microsoft.com/en-us/te...ance&av=TPL000 Mike "Mike Pirolli" wrote: How do I get the formula, that will allow my spreadsheet to work like a bankbook. to subtract and add the debits and credits and give me the balance in another colume. EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Worksheet
Hi,
Suppose you enter credits in column A and debits in column B and both start on row 2. In C2 enter the following formula A2-B2 in C3 enter =IF(COUNT(A3:B3),C2+A3-B3,"") Copy this formula down as far as necessary. If you choose to enter debits as negative numbers you will need to adjust the formulas a little. There are many other approachs -- If this helps, please click the Yes button Cheers, Shane Devenshire "Mike Pirolli" wrote: How do I get the formula, that will allow my spreadsheet to work like a bankbook. to subtract and add the debits and credits and give me the balance in another colume. EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare excel worksheet and output difference to new worksheet | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) |