Re: running balance

From: Lady Layla (nospam_at_nowhere.now)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 13:57:51 -0500

Why would you have to enter this as an array -- works as a simple formula (no
need to do the ctrl+shift+enter) What would an array do that a normal formula
wouldnt?

"cwilson" <cwilson@discussions.microsoft.com> wrote in message
news:AFD250C2-42AF-4BFB-A563-43442574663F@microsoft.com...
: how about an array formula?
:
: Type into D2 (or where ever you want to see the running balance)
: =sum(A2:A1000)-sum(B2:B1000)-sum(C2:C1000) then do ctrl+shift+enter
:
: each time you enter new dollar amounts in the columns (all as positive
: numbers by the way) the amount balance in D2 will change to reflect the new
: transaction.
:
: HTH cwilson
:
: "Jackie" wrote:
:
: > Hi I need help figuring out a formula for a running balance. I have 3
: > columns one called deposits, another called petty cash disbursements and
: > another called expenses. I want to be able to know how can I get the total
: > amount of money that I have on an account even though I keep on entering
: > different dollar amounts at all times. I know that the formula =A39-B39 is
: > giving me the amount for the first two columns, but I don't know what to do
: > for the third column.
: >
: > I would really appreciate it if someone can help me out.
: > Thanks.
: > Jackie

Relevant Pages

  • Re: large data in memory
    ... It sounds like you will be making inefficient use of a significant amount of space. ... For example you may find that you can access only the records actually required with a single query by using an "inner join". ... If you are using only a few elements from a very large array, a "hash table" might provide a better storage solution. ... The id is only a 27 char string. ...
    (microsoft.public.vb.general.discussion)
  • Re: how to vary sorts block?
    ... I want to be able to sort that array by ... def initialize ... Thing = Struct.new(:name,:amount) ...
    (comp.lang.ruby)
  • Re: [OT] Re: model implementation
    ... if my model consists of a number of units that hold a ... >> simulation or calculate the change in the units over time? ... > the array after asking for the simulation length in days. ... > indicate the amount of the content of each of the levels to be added (or ...
    (comp.lang.cpp)
  • Re: complicated array
    ... > the columns are account name and amount of order. ... > I need the section where this array would be to look as ... > could refer to that cell to understand its associated ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Date representation
    ... allocate the arrays, rewind the file and read in the data. ... the amount of data is not very large. ... Previously I just allocated some ridicously big array and it also ... Below you will find a routine to convert the dates to JULDAG. ...
    (comp.lang.fortran)