Percentage Issue

  • Thread starter Thread starter jlojones821
  • Start date Start date
J

jlojones821

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentages 2
Strange request: Counting cells and percentages 4
Sorting percentages 2
Finding percentages 1
Get the Average percentages? Also, #DIV/0! error 1
Access Group by precinct, calculate percentage of older voters 0
Work out the percentage 4
Running YTD Percentages 1

Back
Top