View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Problem calculating percent change

On Tue, 17 Oct 2006 20:04:15 -0400, Ron Rosenfeld
wrote:

On Tue, 17 Oct 2006 12:41:03 -0700, Patrick
wrote:

Ron,

That's an excellent point, and one that I also am considering...
It's not for financial data, but rather quantity of products sold.

Nevertheless, your comment is well appreciated and does tend to make me
re-consider the whole approach.


I would think so. Although I'm not sure how Quantity of Products sold could be
a negative number. Maybe it's the net of product purchased vs product sold;
but if that's the case, I would think the same analysis would apply.

--ron


The above doesn't read right and might be offensive.

What I meant to write, in addition to not being sure how negative values would
apply to quantity of products sold, is that I would think that similar
principles would apply if one or both of the values were negative, or zero.


--ron