View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default Change over time fornula

In e2: =if(b2=0,1,d2/b2). Format the result as a percent.

"Trevor" wrote:

Trying to calculate change % with a couple criteria. Here's what I'm doing...
Column a (labels) easy--data input
Column b (2004 number) easy--data input, all =0
Column c (2005 number) easy--data input, all =0
Column d (Change #) easy [=c2-b2] conditional format red font for neg#
Column e (Change %) here is the problem...I need to iclude all of these
conditions.
* if d2=0, then e2 should show "No Change" (or display 0%)...pretty easy so
far
* if there is a difference between b2 and c2, then change over time formula
is ((c2-b2)/b2). No problem s long as b2 is NOT zero
* trouble is, if b2=0 then I get a DIV error in the change over time
formula. I need any change from zero in 2004 to any number 0 in 2005 to
display "100%"

Would like some help creating a formula to care for this. Thank you.