[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
bsd13
Newbie

Joined: 01 Apr 2007
Posts: 2

 Posted: Sun Apr 01, 2007 9:13 pm    Post subject: Simple calculation help... I'm sure this is really simple, but I'm at a loss. I'm making a debt payoff sheet. In column 1 I have the total of each debt, in column two I have the amount paid towards column 1, and in 3 I have column 1 - column 2. Fairly simple. Problem is that I would like column 2 to keep track of how much total has been paid. For example say the figure in column 1 is \$15,000.00 and pay \$5,000.00 and put it into column 2, column 3 reflects the new balance (\$10,000.00) but if a month later I make another payment and say put \$2,000.00 into column 2 instead of column 3 saying \$8,000.00 it says \$12,000.00 because it (column 2) doesn't save the previous input payment. Does that even make sense to anyone and if it does how can I go about fixing this? Thanks!
squenson
Super User

Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia

 Posted: Sun Apr 01, 2007 9:31 pm    Post subject: bsd13, I understand what you want but I consider it very risky. Suppose that instead of typing \$3,000 in column 2, you type \$300 then press Enter. You will have difficulty to reverse the calculation. And if you have several updates to be done and are interrupted during your task, how will you be *sure* that you have entered the values for each row? What I suggest is that you create a new row for each payment, then you can use the SUM or SUMIF functions to calculate the sum of payments from an individual. It will also allow you to make further analysis (like how much was paid within a month). If you really, really need such feature, a macro can do it. Let us know._________________Help us to help you: Add [Solved] to the title of the thread if you agree with the answer >>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<
bsd13
Newbie

Joined: 01 Apr 2007
Posts: 2

 Posted: Sun Apr 01, 2007 9:35 pm    Post subject: Thanks for the reply. I'll try it the way you suggest and see how it goes. Unless someone else has a better idea?
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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