math percentages

[AceFI]

hi all.. not a mathleet by any means..

I sold 1 of product A last year, i sold 2 this year..
% increase;
(This year - last year) / last year = 100% increase

I sold 5 of product A last year, i sold 0 this year
using the same formula = -100% (shouldn't it reflect -500%)?
thanks

 

[jtakw]

Hi,

That's actually correct, because the 5 represents 100% of your annual sale, not 1.

If you had sold 100 last year, and 0 this year, it would still be 100% decrease, not -10000%.

 

[AceFI]

ok... for the purpose of what i'm report, i need it to show -500%

 

[jtakw]

But that would not be a legitimate percentage decrease calculation...

Book1
	A	B	C	D
1	Last Year	This Year	%Decrease	Your logic
2	5	0	-100.00%	-500%
3	5	2	-60.00%	-300%
4	5	3	-40.00%	-200%
Sheet557

Cell Formulas
Range	Formula
C2	=(B2-A2)/A2