-----Original Message----- From: Barry Premeaux <bpreme...@gmail.com> To: users@global.libreoffice.org Sent: Mon, 13 Apr 2015 16:17 Subject: [libreoffice-users] Basic Calc Question
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. Revised reply: Try this in F5 =IF(E5=0,0,SUM(F4,E5)) or probably better =IF(E5="","",SUM(F4,E5)) -- Jim -- To unsubscribe e-mail to: users+unsubscr...@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
