A
Alan
I have an Excel file (using 2003) that has a row of entries for
actual expenditures for each month (months in columns). I want to
calculate the cumulative expenditures, plot them when actual
expenditures are entered, and not plot them when actual expenditures
are not entered. I cannot figure out how to do this with the IF
statement or conditional formatting. Everything I try leads to a "$0"
which is then plotted. (The fields are formatted as currency, so the
"$" is there.)
If I just leave the cumulative expenditures field blank, then it
is not plotted, but I have to enter the formula for the last month
each month when I update the spreadsheet.
Is there a way to do this? Thanks, Alan
actual expenditures for each month (months in columns). I want to
calculate the cumulative expenditures, plot them when actual
expenditures are entered, and not plot them when actual expenditures
are not entered. I cannot figure out how to do this with the IF
statement or conditional formatting. Everything I try leads to a "$0"
which is then plotted. (The fields are formatted as currency, so the
"$" is there.)
If I just leave the cumulative expenditures field blank, then it
is not plotted, but I have to enter the formula for the last month
each month when I update the spreadsheet.
Is there a way to do this? Thanks, Alan