Re: [libreoffice-users] Basic Calc Question

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