Hi,
I am currently working on a yearly comparison of sales by individual month. I am having a problem finding the right formula that will not return the error #DIV/0 if the month the previous year was 0 or vice versa.
I need a formula that will calculate percentage increase/ decrease and recognise that there has been an increase if the previous year's month was a 0 and this years month is say 14, instead of returning the error.
Hi,
you can't calculate percent increase from "0", that would be a division by zero. If you think about it, if "0" is 100%, how many percent is 14? You can't tell, it doesn't make sense.
You could, however, calculate the absolute difference between the values of the two years. Or you could make a formula that returns something like "Last year was 0" if last year was actually zero. Something like this:
Please Login or Register to view this content.
Last edited by RHCPgergo; 12-10-2012 at 08:07 AM. Reason: grammar
Thank you for your reply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks