if a = 5.00 (TY earnings)
if b = 0.00 (LY earnings)
the percent change is (a-b)/b is really a 100% increase, not DIV/0!
and if a=-5.00, then it's a 100% decrease.


=IF(b29=0,100%,(a29-b29)/b29)
..... what if a29 is negative

Thanks
--
Sony Luvy