>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 <[email protected]> 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 <[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
