Hi,

If you will never have both years without sales, then try this

=IF(A1,(B1-A1)/A1,1)

Where A1 is the old year sale's and B1 the new year's sales

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Picman" wrote:

I need to calculate the % difference between 2 years of sales, however one
year or the other may be a zero value (ie new customer this year or old one
last year that has no sales this year). Zero sales last year with sales this
year = 100% or sales last year with zero sales this year = -100%, or if there
are sales in both years calculate the % difference.