Re: [libreoffice-users] Basic Calc Question

Thank you.  I will give this a try.  I guess a better description might
have been a basic check book.  The balance cell is empty until an
associated transaction is entered.  Then it updates the balance to reflect
the transaction just made.  If F4 is current balance, a transaction entered
in E5 updates F5 to reflect the new balance.  F6, 7, 8......  are still
blank.

On Mon, Apr 13, 2015 at 6:24 PM, Dave Liesse <dsliesse@liessefamily.net>
wrote:

> Speaking as an accountant, I'm not sure why you would want the balance to
> show 0.  Nevertheless, what you need is:
>
> =IF(E5=0,0,F4+E5)
>
> And, of course, you want to copy that to each cell in the F column.
>
> Dave Liesse
> Skingco Services, LLC
>
>
>
>
>
> On 4/13/2015 16:16, Barry Premeaux 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