Calculating Percent Change - Comparison Result is Negative

[Stilltrader47]

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

 

[Jacob Skaria]

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

=(B1-A1)/ABS(A1)

If this post helps click Yes

 

[Hans Knudsen]

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/resources/documents/doe-help.htm
(under heading Net Income)

Hans Knudsen