Alan Boba wrote:
On Thu, Apr 16, 2009 at 5:34 PM, DDowney <[email protected]> wrote:
Is it possible to use text cells in if/else statements in Calc? Im using
Calc to do a household budget spreadsheet & am including a sheet which
will track and chart all electricity bills, for instance, through the
year. Can you have an If statement that says, for Januarys sheet, if
Not sure if this would be helpful. It seems as if you will have data like
this...
Month Year Category Amount
01 2009 Electricty $100
01 2009 Cable $70
02 2009 Electricty $100
02 2009 Cable $70
and want information like this...
Year/Month
2009/01 2009/02 Total
Electricty $100 $100 $200
Cable $70 $70 $140
Totals $170 $170 $340
If this is what you want then "Data > DataPilot > Start..." takes you down
that path. Your data can be on the first tab and the table, a "crosstab,"
can be on the second. That way data is added on the first tab as it
accumulates. The table is updated as needed to display new results on the
second tab. Calc updates the totals, inserts new rows for categories and
adds columns for months on its own. Formulas that can be hard to maintain,
with specific categories written into the formula in individual cells , are
avoided.
have you tried using gnucash? i've used to track our household income,
budget and all. you can even download all your transactions from your
bank - if they offer online banking options and import these into the
program. all you have to do is to categorize them and off you go with
being able to track you expenses for groceries, insurance, utilities,
etc... might want to give it a try. here's the link to their website...
and it's free by the way.
http://www.gnucash.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
