Please help me write a formula that calculates the percent change when:

The current result is 11%

The prior result is -1.89%

I am attempting to compare the current result improvement to the prior
result, hence my formula is:

(11%--1.89%)/-1.89% (the calculated result is -682.01%)

The result should be positive, like 1000% change (improvement), shouldn't it
be?

Thanks for helping me with this formula.

Sony

A1 = prior result -1.89%
B1 = current result 11%

=(B1-A1)/ABS(A1)

If this post helps click Yes
---------------
Jacob Skaria


"Stilltrader47" wrote:

Please help me write a formula that calculates the percent change when:

The current result is 11%

The prior result is -1.89%

I am attempting to compare the current result improvement to the prior
result, hence my formula is:

(11%--1.89%)/-1.89% (the calculated result is -682.01%)

The result should be positive, like 1000% change (improvement), shouldn't it
be?

Thanks for helping me with this formula.

Sony

Microsoft has published the following
http://support.microsoft.com/kb/214078

In my opinion percent change is meaningless when you go from a loss to a
profit or vice versa.

See also:
http://online.wsj.com/public/resourc...s/doe-help.htm
(under heading Net Income)

Hans Knudsen




"Stilltrader47" wrote in message
...
Please help me write a formula that calculates the percent change when:

The current result is 11%

The prior result is -1.89%

I am attempting to compare the current result improvement to the prior
result, hence my formula is:

(11%--1.89%)/-1.89% (the calculated result is -682.01%)

The result should be positive, like 1000% change (improvement), shouldn't
it
be?

Thanks for helping me with this formula.

Sony