View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlojones821 jlojones821 is offline
external usenet poster
 
Posts: 12
Default Percentage Issue

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.