Calculating Percent Change - Comparison Result is Negative

  • Thread starter Thread starter Stilltrader47
  • Start date Start date
S

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
 
A1 = prior result -1.89%
B1 = current result 11%

=(B1-A1)/ABS(A1)

If this post helps click Yes
 
Back
Top