On Thu, Apr 16, 2009 at 5:34 PM, DDowney <ddowney...@eircom.net> 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.
