I am monitoring a sales incentive program at work, and I have to create a
spreadsheet with quarterly sales from last year, quarterly sales from this
year, and a percent increase/decrease for each state. I am using this formula
for the % Change field with I2 being 1st Qtr 2008 totals, and E2 being 1st
Qtr 2007 totals

=(I2-E2)/ABS(E2)

which gives me the correct results, with the following exceptions. If all
the values are zeroes, I get the #DIV/0! result and I want it to display 0%;
if the sales from 2007 are a positive number, but the sales from 2008 were
zeroes, I get a -100% BUT if the sales from 2008 are a positive number, and
the sales from 2007 are zeroes, then the % Change field does not compute. Can
you tell me what I can do?

Thank you