In reality, the only expenses of the "Credit Card" category should be the annual fee (if there is one) and possibly, any interest or other late payment charges. For the expenses listed (taken from that template) the largest two were Home (37%) and Credit card (36%). One issue I had with this template is its considering "Credit Card" as a category, The template also included a circle chart showing the percentage of each expense category as a portion of total expenses. IF either cell has an entry, IF clls the core formula (shown in bold) which gets the value from G1, adds the SUM of values in rows 3 to 'this row' of column E, and subtracts the SUM of values in rows 3 to 'this row' of column F to determine the current balance, and places that result in 'this row' of column G. If the result is less than 1, IF places a null string in its cell, and exits. LEN gets the LENgth of the entries in 'this row' of column E and adds the LENgth of the entry in 'ths row' of column G. The part in normal weight type is the switch.
The formula has two parts-a core formula that calculates the current balance, and a 'switch' part that prevents the calculation until there is a value in that row of column F or G The formula shown below the table is entered in cell G3, then filled down to the end of column G. Putting in and out amounts in separate columns (and revising the formula in the Balance column) allows all transactions to be entered as positive numbers. The original used a single column for deposits and withdrawals, and required entering withdrawals as negative amounts.
Here's a revised version of the main table, constructed in a post '09 version. Version 2 of Numbers (Numbers '09) included a Check (sic) Register template to keep track of deposits and expenditures in a chequing account.
0 kommentar(er)
