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
