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

I think this is what you might be looking for. =SUM((J15-H15)/ABS(H15)) I
am very rusty at math so please check it. If I am wrong it would be nice if
you gave me an example of the problem and what the answer is so I can be sure
any other forumla I come up with works.

"cardfan057" wrote:

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