Ask Your Question

Checkbook balance - how?

asked 2019-07-24 20:56:40 +0100

Jimmer gravatar image

I know previous balance - check + deposit = current balance, but how do I show the current balance only if there is a dr or cr? I put in the formula all the way down the balance column, then it shows the current balance all the way down the column. Want to just show a balance after each check or deposit. 3 columns

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-24 21:19:53 +0100

Pete of Ebor gravatar image

updated 2019-07-24 21:21:15 +0100

You could try using IF/AND - If both 'cr' & 'dr' are blank, then make balance blank otherwise calculate the balance..

=IF(AND('dr'="",'cr'=""),"",'prev bal' + 'cr' - 'dr')

Remember, if you accidentally miss a row out, it will not calculate.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-24 20:56:40 +0100

Seen: 32 times

Last updated: Jul 24