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.