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 <[email protected]> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: [email protected] 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
