Been a while, but let's get down to it, you will remember that I left you with the task of playing with the formatting for the Title. The merged block of cells at the top of the spreadsheet.
Following on from the basic formatting, let's sort out the formulae (plural of formula i.e. calculation).
Initially we want a balance to start the proceedings. So we will put the initial value of 0 in G5 (or you can put your own value in here). And dont forget to format the cell as currency.
 |
| The Spreadsheet so far showing the starting balance of £0.00 (after formatting the cell for currency) |
Now the cell E6, will contain a formula which will be unique to that cell, as it will be referring to the G5 cell, where as the remaining column calculations will be based on the cell above (e.g. the calculation in E7 will refer to E6 as the balance).
OK the calculation for cell G5 is:
=if(D6="";"";D6+G5)
The cell below will contain the formula
=if(D7="";"";D7+D6)
See below
 |
| This is the spreadsheet with the formulae entered (which would be blank without any values entered) Looking at the picture above I have put 2 entries into the spreadsheet, showing the calculated values, which as you can see, incorrectly calculates the cash debit on row 7. The value is added to the balance from D6 instead of reducing the balance. Clearly we need to do something about this. Think about it and we will deal with this issue next time That's all for now Thank You Prometheus1618 |
No comments:
Post a Comment