Excel question?

Question

I have to make a simple function for Excel. I have 2 rows that have to be added to make a third row. I'm supposed to use it as if it a checkbook. All my credit is in E4-E12 and my debit is F4-F12. I'm wanting column G to be the balance.
What is the correct way of making this work out?

When I paste =E4-F4 into G5-G12 it doesn't auto change, it all stays as =E4-F4 which makes it the same number all the way down. Is there a way to get E-F = G and then the 2nd row be E2 - F2 +G = G2? and so on and so forth

Answer 1

Let's assume it's G4 and the previous balance is in G3
=G3 + E4 - F12
copy G4 and paste it into G5-G12

Gives you the running count...

In G4 type "=" up + left left - left "enter"

Answer 2

You can just do E4+F4 for G4. And copy that and paste down the G column. I think it automatically change row#. Or just go to G column select E column + select F column.

Answer 3

In the checkbook type spreadsheets I have made, you have to consider that to keep an ongoing accumulating balance going, you have have a beginning/new balance column, your debits column, your credits column, and a final/current balance column on each row.

The key is that the current column total needs to be copied to the next row's beginning balance column so that the formula in the current column will grab the right starting figure and add/subtract the debits and credits as entered.

So consider the following the following pattern:

Row 1 A1 = Starting balance = 0
B1 = Credit
C1 = Debit
D1 = current balance = A1+-B1+C1
Row 2 A2 = D1 = new current balance (in essence like copying formula
from D1 cell to A2 but using cell reference instead
B2 = Credit
C2 = Debit
D2 = new current balance = A2 - B2 + C2
Row 3 A3 = D2
B3 = Credit
C3 = Debit
D3 = A3 -B3-C3 = current balance

If you copy the pattern for the A column starting with the formula in A2 and copy down the whole A column for each row you need, Excel will or should keep the pattern.

If you copy the pattern for the D column starting with the formula in D1 and copy down the whole D column for each row you need, Excel should keep the pattern going and your current balance in each row should continue accumulating as you enter amounts in Columns B and C.

Answer 4

in G4, type =E4-F4. Then copy and paste it into G5-G12, the formula will change. You should get the answer

Answer 5

E ---------F--------G
creditdebitbalance
100.00 $200.00 ($100.00)
45.00 $89.00 ($44.00)
33.00 $66.00 ($33.00)

Here we assume a credit is money you deposit in your account, and a debit is a check you write against it... The roles switch when the bank, or you, are looking at your account!

Fill in E and F
Right Click columns E and F and select format, choose Format for Currency with negative numbers in parens.
for G2, enter the formula =E2-F2
select the result in G2 and pull the fill handle down to the last row of data (in this case, to G4). All cells will now inherit the formula using the respective pairs of E and F.
Right Click column G and select format, choose Format for Currency with negative numbers in parens.

Answer 6

put this in the g4 cell =E4-F4 then copy this cell on down and it should automatically adjust it for you.

Answer 7

try ctrl ~ and the formulas should all show up and then it will show you where you are going wrong.