OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Ledger questions

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
pete.zhut
Newbie
Newbie


Joined: 20 Oct 2005
Posts: 1
Location: New Jersey

PostPosted: Thu Oct 20, 2005 4:11 am    Post subject: Ledger questions Reply with quote

I have a ledger that I am trying to create with OO Calc. I would like to have
a formula (or function or macro) that will do the following: When I enter a value in a block it will take that value and give me the sum in another block, but I don't want to have to create functions for each cell. Here is a visual:

---A------------------------B----------------C
1 Starting balance---1000.00----1000.00
2 Check-----------------(-250.00)---750.00

What I want is for the total calculation, the value of C and what ever row is above the newest entry, and the newly entered value to be automatic. I know that I can do this manually with C2=SUM(C1:B2), but is there a way to do this so that when I make a new entry that the total is calculated?

Thanks
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Thu Oct 20, 2005 5:26 am    Post subject: Re: Ledger questions Reply with quote

pete.zhut wrote:
I have a ledger that I am trying to create with OO Calc. I would like to have
a formula (or function or macro) that will do the following: When I enter a value in a block it will take that value and give me the sum in another block, but I don't want to have to create functions for each cell. Here is a visual:

---A------------------------B----------------C
1 Starting balance---1000.00----1000.00
2 Check-----------------(-250.00)---750.00

What I want is for the total calculation, the value of C and what ever row is above the newest entry, and the newly entered value to be automatic. I know that I can do this manually with C2=SUM(C1:B2), but is there a way to do this so that when I make a new entry that the total is calculated?

Thanks


At the very simplist just copy cell C2 and paste it into C3. When you enter data in B3 it will take the values from C2 and B3 and put them in C3. The equations are relative in postion.

I would suggest having a look at some of the User's Guide chapters at http://oooauthors.org/en/authors/userguide2/calc/draft_pub/ for some general information .
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Thu Oct 20, 2005 4:25 pm    Post subject: Re: Ledger questions Reply with quote

pete.zhut wrote:

---A------------------------B----------------C
1 Starting balance---1000.00----1000.00
2 Check-----------------(-250.00)---750.00

What I want is for the total calculation, the value of C and what ever row is above the newest entry, and the newly entered value to be automatic. I know that I can do this manually with C2=SUM(C1:B2), but is there a way to do this so that when I make a new entry that the total is calculated?


In C2 you put this: =IF(B2="";"";C1+B2)

Now look at the formula cell and notice a tiny rectangle [handle] in the lower right corner. Grab this with your mouse and drag down th column. This copies the formula for you. Your entries will be in column B and the calculated sum if entered as a positive value, or differecne if entered as a negative value will be reflected in column C. The cells in column C will be blank if there is no entry in their opposing cell in column B.

David.
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Fri Oct 21, 2005 12:02 am    Post subject: Reply with quote

I have often used this method but it has a drawback which is that adding a row in the middle of B1:Bn breaks the formula and can (if you dont spot it )lead to a wrong final total.

However:
In C2 you put this: =IF(B2="";"";$B$1:B2)
and drag down , this will not happen.
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
cwongcpa
General User
General User


Joined: 16 Jul 2006
Posts: 18

PostPosted: Mon Jul 17, 2006 5:17 pm    Post subject: Reply with quote

Carl,

Do you still need help ? I am also using excel to do with my ledger in my audit firm. If you still need the solution, I could post the formulas and discuss with you.

chris
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Mon Jul 17, 2006 9:22 pm    Post subject: Reply with quote

Thanks for the thought. I am ok.
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group