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
|