Thread: Percent change
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cardfan057
 
Posts: n/a
Default Percent change

I need a formula that will show percent change from the pervious month, the
one I came up with is =SUM((D19-B19)/B19), but this isn't accurate when the
previous month is a loss(-) ie. h19 & f19.


Jan Feb
March Apr
Net Income(Loss) (B19)363 (D19)15 (F19)-572 (H19)411
Percent of Change

--
cardfan057