OK...I've tried to figure this out and I'm not having much luck. I'm trying
to set up formulas to figure out the difference in the volume of business at
different areas of the resort that I work at. In most cases what I have done
works....but in a couple of instances we did business this year but not last
year so where as I want it to tell the percentage of increase of business I
get the DIV/O error. Is there a universal formula that would give me those
results but still the correct results I'm getting in the other cells as
well....I really want the same formula everywhere because it doesn't happen
all that often.

If A1 is last year's business:
Then =IF(A1<0,Your_Percentage_Formula,"What you want to show when there was
no business last year")

Tyro

"jlojones821" wrote in message
...
OK...I've tried to figure this out and I'm not having much luck. I'm
trying
to set up formulas to figure out the difference in the volume of business
at
different areas of the resort that I work at. In most cases what I have
done
works....but in a couple of instances we did business this year but not
last
year so where as I want it to tell the percentage of increase of business
I
get the DIV/O error. Is there a universal formula that would give me
those
results but still the correct results I'm getting in the other cells as
well....I really want the same formula everywhere because it doesn't
happen
all that often.