Ask Your Question
0

What would the formula be to create a checkbook register

asked 2017-07-12 23:43:47 +0100

Bella gravatar image

updated 2017-07-13 03:53:47 +0100

I was trying to keep the question simple but apparently didn't give enough information. I want a spread sheet with column headings: date, check#, transaction description, debit, credit and balance. On each row I will input either check data (debit) or credit data . I want to see the balance after each row that data is added. For each row if there is a debit, it should be subtracted from the balance and if there is a credit, it should be added to the balance. I'm only asking about the debit, credit, balance part. I hope I made myself clearer.

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2017-07-16 04:23:57 +0100

Bella gravatar image

Thanks for your suggestions, robleyd. This web site works for me: http://www.wikihow.com/Create-a-Simpl... Problem solved.

edit flag offensive delete link more
0

answered 2017-07-13 00:49:41 +0100

librebel gravatar image

updated 2017-07-13 04:18:24 +0100

Hello @Bella, Suppose your opening balance is in cell I1 ( i1 ), and that your debit, credit, and balance are in columns D, E, and F, then you could write as formula in cell F2:

=SUM(I1;SUM(D2:D2)*-1;SUM(E2:E2))

then as formula in cell F3:

=SUM(I1;SUM(D2:D3)*-1;SUM(E2:E3))

etc.

edit flag offensive delete link more

Comments

In OP's case, the example given has Debit in D and Credit in E, so "=E1-D1"

robleyd gravatar imagerobleyd ( 2017-07-13 04:17:44 +0100 )edit

@Bella i updated my answer based on your added information.

librebel gravatar imagelibrebel ( 2017-07-13 04:19:47 +0100 )edit
0

answered 2017-07-13 05:37:42 +0100

robleyd gravatar image

here is a quick sample spreadsheet as a guide.

finances.ods

edit flag offensive delete link more

Comments

Thanks robleyd, That's what I want but how do I make the rest of the balance column blank when there are no entries in the debit/credit columns?

Bella gravatar imageBella ( 2017-07-14 02:24:57 +0100 )edit

Thanks robleyd. That is what I want but if I copy and paste the formula down the balance column, how can I get the cells after t he last balance entry to be blank?

Bella gravatar imageBella ( 2017-07-14 03:40:58 +0100 )edit

In my example sheet, replace F3 with

=IF(AND(ISBLANK(D3);ISBLANK(E3));"";F2-D3+E3)

and copy or drag down.

robleyd gravatar imagerobleyd ( 2017-07-14 04:01:30 +0100 )edit

Well, I entered the new formula and all it did was spell out the formula. Are there supposed to be spaces between the ; and the ""? Also there are red wavy underlines under the ISBLANK's like it doesn't like the spelling

Bella gravatar imageBella ( 2017-07-14 21:29:25 +0100 )edit

Put it in the Input line at the top, not in the cell itself. And don't forget the = sign at the beginning.

robleyd gravatar imagerobleyd ( 2017-07-15 05:53:12 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-12 23:43:47 +0100

Seen: 367 times

Last updated: Jul 16 '17