Share via

What is the formula I would use to get a balance in a check register?

Anonymous
2023-04-01T23:26:26+00:00

I am inputting my checkbook register into an Excel spread sheet and need to take the Balance in column F, add the input of the deposit from column D, then subtract the expenses in column E, to get the ongoing sum in the balance column. I need a formula that carries from one line to the next. Can someone help me with the formula?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2023-04-02T03:58:06+00:00

    Hi Bonnie_MM!

    Here is the formula you can use:

    =F2+D3-E3

    Assuming that you are starting in row 2 of your Excel sheet and that the Balance, Deposit, and Expense columns are in columns F, D, and E, respectively, this formula will add the previous balance (in column F) to the current deposit (in column D) and then subtract the current expense (in column E) to give you the ongoing balance.

    You can copy this formula and paste it into the Balance column for all of the rows in your sheet, and it will automatically adjust for each row based on the values in the Deposit and Expense columns.

    Kindly let me know, if you require additional assistance, I will be glad to help further.

    Best Regards, Shakiru

    7 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-01T15:27:53+00:00

    Hello. Can the formula be adjusted to show empty cell if there is no entry in the payment or deposit cell? I would prefer the last balance didn't run down the spreadsheet, but want the formula already there.

    Thank you,

    Renee

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-04-02T20:45:40+00:00

    Hi Bonnie_MM! Here is the formula you can use: =F2+D3-E3 Assuming that you are starting in row 2 of your Excel sheet and that the Balance, Deposit, and Expense columns are in columns F, D, and E, respectively, this formula will add the previous balance (in column F) to the current deposit (in column D) and then subtract the current expense (in column E) to give you the ongoing balance. You can copy this formula and paste it into the Balance column for all of the rows in your sheet, and it will automatically adjust for each row based on the values in the Deposit and Expense columns. Kindly let me know, if you require additional assistance, I will be glad to help further. Best Regards, Shakiru

    Hi Shakiru,

    Your formula worked perfectly!!! Thank you so very much for sending it so quickly!!! I was of incredible help! Bonnie_MM

    1 person found this answer helpful.
    0 comments
  3. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2023-04-01T23:33:07+00:00

    Hi,

    Share some data to work with.

    0 comments