1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

EXCEL Formula Needed

Discussion in 'Business Applications' started by lwoodside, May 4, 2010.

Thread Status:
Not open for further replies.
  1. lwoodside

    lwoodside Thread Starter

    May 4, 2010
    First time using Excel. I am trying to produce a Bank Register Log which simply states the following:

    Column #1 = Check Number
    Column #2 = Date
    Column #3 = Description of Transaction
    Column #4 = Debit (-) (This will the amount of the check or the transaction amount)
    Column #5 = Fee (-) (This will be bank fees or misc. charges)
    Column #6 = Deposits (+) (This is the amount deposited)
    Column #7 = Balance (The result of a Debit, Fee or Deposit)

    I am using Excel for Mac.
  2. WendyM

    WendyM Retired Trusted Advisor

    Jun 27, 2003
    Hi lwoodside, welcome to TSG.

    I'm not sure exactly what you're trying to do, but it sounds like you will be manually entering the data for columns #1-6, is that correct? And you just need to calculate the value in column 7? If so, assuming you start in Row 1, the formula for G1 would be =sum(d1:f1). That assumes that the debits and the fees are entered as negative numbers. If they're entered as positive numbers, the formula would be =f1-d1-e1. If you want to keep a running total (the way you would see on a bank statement), then G1 would be the same formula as above and G2 would be =g1+f2-d2-e2. Once you have that formula in place, you can select the cell and drag it down the length of your data. Excel will automatically change the formula to use the cells in teh correct rows. Hope that makes sense.
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/921105

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice