ExcelBanter - Percent change

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Percent change (https://www.excelbanter.com/excel-discussion-misc-queries/87722-percent-change.html)

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

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

That worked great, thanks
--
cardfan057

"Abode" wrote:

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

"Abode" wrote in message
...
"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

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.

As has been asked in another thread, why have you used SUM() here?
Why not just =(J15-H15)/ABS(H15) ?
Have you looked at what SUM() does?
--
David Biddulph

Hahaha. Yeah. While testing the code to make sure it worked properly I
removed Sum because it wasn't needed... But when I replied with the answer I
just took cardfans formula and added ABS... I forgot that SUM wasn't needed

"David Biddulph" wrote:

"Abode" wrote in message
...
"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

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.

As has been asked in another thread, why have you used SUM() here?
Why not just =(J15-H15)/ABS(H15) ?
Have you looked at what SUM() does?
--
David Biddulph