Bookkeeping Ledger Template?
Arcadian
with Excel 2007, which I can download?
Gord Dibben
http://office.microsoft.com/en-us/templates/results.aspx?qu=ledger&av=TPL000
Gord Dibben MS Excel MVP
Arcadian
> Browse through this list. May be something you can use.
>
>
> Gord Dibben MS Excel MVP
>
>
>
> On Sat, 25 Aug 2007 21:53:57 -0700, Arcadian <philo...@verizon.net> wrote:
> >Is there a template of a three-column bookkeeeping ledger, compatible
>
> - Show quoted text -
Thanks, Gord, but none of them are what I'm seeking. Anyway, I just
made my own template & now have another plroblem. I want to insert
the formula to add to the balance if there's a value in the debit
column or subtract from the balance if there's a value in the credit
column, but I don't know how to say value or blank value in Excel
language. How do I say "If x=a value" or "if y=blank"?
Gord Dibben
=IF(A1>0,do something) for a cell with a positive value
=IF(A1="",do something else) for a cell with no value
=IF(A1<=0,do something different) for a negative value or a 0
Gord
Arcadian
> In simple terms.........
>
> =IF(A1>0,do something) for a cell with a positive value
>
> =IF(A1="",do something else) for a cell with no value
>
> =IF(A1<=0,do something different) for a negative value or a 0
>
> Gord
>
>
number. In my research I found the IF ISBLANK function. Could I use
that in my situation? From what I've seen it goes:
IF(ISBLANK(location)true, false). What I want for my formula is
IF(ISBLANK(Credit cell)add value in debit cell to above balance, minus
value in credit cell from above balance).Would this work?
Arcadian
current debit - current credit, which makes a lot of sense. I tried
that & now got new problems.
When clicking & dragging a formula, to copy it down a column, Excel
2007 doesnt alter the position values to suit its cell position as in
Excel 2003. So all it does is repeat the function of the first row's
values over & over again. So to repeat the formula with different
location values, I have to enter a different formula for each row,
which is a lot of typing.
When entering a value in the opening balance cell, it repeats all the
way down the column. How do I program it so that a value only appears
when a value is inserted in its row?
Gord Dibben
references or your calculation mode may be set to manual.
Change to relative references or set calculation mode to automatic.
Second question...............
Trap for no data.
=IF(A1="","",A1)
Gord Dibben MS Excel MVP
Len Shapiro
The basic input is a check register.
The output are P&L statements: current, monthly, quarterly and year-to-date.
It is a very comprehensive program, which include expense payments by:
check, cash, debit card, and credit card.
It has a checking account reconciliation sheet.
The chart of accounts may be customized to your business.
I have just started to market it.
But I could send you a FREE copy for your evaluation.
Just promise not to give it to others.
Send me your E-mail address and I will send you the template as an
attachment. It has no Macros, nor viruses, etc. It is just a spreadsheet.
Reply to: lensh...@hotmail.com
Gord Dibben
Maybe you should upload it to a file hosting site so's we can download it
without giving you an email address.
Gord Dibben MS Excel MVP
On Sat, 17 Oct 2009 03:15:13 +0800, "Len Shapiro"<lensh...@hotmail.com>
wrote: