Re: [libreoffice-users] Basic Calc Question

> Try this in F5
> =IF(E5=0,0,F4+E5)

I tried the other formulas, but kept getting error codes.  This one works
and gives me the results I was looking for.  F5 remains blank until their
is an actual data entry in E5.  Thank you for the help.

Barry

On Tue, Apr 14, 2015 at 12:10 AM, Piet van Oostrum <piet@vanoostrum.org>
wrote:

> Barry Premeaux wrote:
>
>  > 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.
>
> OK, that makes sense. So it is not about the transaction being 0, but
> empty.
>
> Here is a working formula:
>
> =IF(ISBLANK(E4);"";SUM(E$2:E4))
>
> I have supposed that the transactions start at row 2. If not you have to
> change the E$2 accordingly.
> --
> Piet van Oostrum <piet@vanoostrum.org>
> WWW: http://pietvanoostrum.com/
> PGP key: [8DAE142BE17999C4]

-- 
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