Help! Open Office.org or Excel.?

Question

I am trying to create a spreadsheet using Open Office.org spreadsheet, which I believe is similar to Excel. My last three columns are D. Credits, E. Debits and F. Balance. How do I tell column F how to calculate the balance in each row. My computer is about to go through the window!

I tried both of the formulas given but it does not work, sorry guys but thanks anyway.

Answer 1

Openoffice Calc uses the same style formulas that MS Office does. So you could do:

=(d1-e1)

and it should do the trick for you

Answer 2

Assuming on Cell F1 you have the title: "Balance:"

type this in F2:

=D2-E2

That should do what you want.

ProTip: The square that highlights the cell you're in (F2), to the bottom right, if you move your mouse over the bottom right corner, a small black plus should appear. If you drag that down the column, you will fill the column with the same function.

That will save you a lot of copying and pasting.

Answer 3

Hi,
I believe Open Office operates in the same way as Excel, so. Use the first row of figures (lets assume it's row 3 for this formula)
Select F3, type in =D3-E3 then hit the enter key. This will give the first balance figure. Following that you select F4 , type in =D4-E4+F3. This will give you the cumulative balance. Copy this formula down as far as you wish.

Job done,

Hope this helps, Graham.

Answer 4

Assuming that the first row is a header and the second row is a carried forward or a starting balance.
The balance in Cell F3 as calculated in Excel should be
=sum(D3:E3,F2)
If debits are shown as positive then you will need to make them negative for this to work.
The next line down will be
=sum(D4:E4,F3)

This will then give you a rolling balance.

I hope this helps.

Answer 5

In the first row you have a carried forward balance
In the second row you have =(CarriedForward) + CreditCell - DebitCell.
In the third row you have = (CellAbove) +CreditCell-DebitCell.
Copy the third formula down all the rows you have transactions in (making sure the cell reference updates as it goes) and you're done.

Answer 6

You can't, unless you have microsoft excel or other program that can be able to read the excel file

Answer 7

F2 = D2-E2