Re: [libreoffice-users] Basic Calc Question

I don't understand the references to a conditional statement and the
reference to 0. But, to create a running balance, you just use a sum with
the first cell anchored. For example, assume entries are in the first
column, A starting at A1, and you want the running total in column B
starting at B1. B1 would have the formula =sum($a$1:a1). Then copy this
formula into the cells below B1, and you will have a running total of the
numbers in column A. Try it and you will see how it works.

b1 has =sum($a$1:a1)
b2 has =sum($a$1:a2)
b3 has =sum($a$1:a3)

and so on.

Mark

On Mon, Apr 13, 2015 at 4:16 PM, Barry Premeaux <bpremeaux@gmail.com> wrote:

> I'm a novice at spreadsheets, and google hasn't turned up an answer.
> Probably because I haven't worded the question properly. I am trying to
> build a general ledger. I have my running balance in the F column and
> transactions in the E column. I am trying to construct a conditional
> statement that takes the running balance in F4 and adds it to the -/+
> transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
> I want F5 to remain $0.00 as well until a new transaction is entered.
>
> Barry
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted