MPG spreadsheet/graphs

[accordaffair]

Is it necessary to use if statements? I didn't use any for my sheet

If you could re-explain your above post in a laymans manner I might understand

edit, I don't understand why you're calculating formulas in the future, couldn't you just calculate the current fill up?

[The G-Man]

The if statements are used to make a cell value zero so to avoid a !#DIV0 error.

This is the formula in cell G48 currently

=IF(C49=0,0,F49/C49)

That statement says that if the value of cell C49=0 then the value of G48 is automatically zero. Else just calculate F49/C49 like normal.

But basically row 49 is currently the totals row, so I don't want ANY formulas to refer to the totals row.

[accordaffair]

well the totals are always much higher than the average 13-14, so how about some sort of AND or IF to say if the value is more than 16, don't calculate it?

[The G-Man]

Thanks so much. What it needed was an or statement in there. I was just not sure on how to nest it within my current statements.
I am going to make a template now.

Edit:
Template made. This one should work perfectly. Will not work with versions of Office prior to 2007.

[accordaffair]

Update, been almost 6 months