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