# EXCEL Formula Needed

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

Not open for further replies.

Joined:
May 4, 2010
Messages:
1
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.

Joined:
Jun 27, 2003
Messages:
4,042
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