need formula 4 %change on both neg and pos movemnt year to yearco
Errata....
On Jan 12, 4:09*pm, I wrote:
If you want to report everything as a percentage change of "profit",
where you consider a loss to be negative profit, you could us:
=(A2-A1)/abs(A1)
[....]
That gives the following results:
A1 * * * * * * A2
Previous * *Current * *%Change
*[....]
*100 * * * * *-100 * * * * 200%
Obvious transcription error. If you do the math or let Excel do it
for you, you'll get the right answer, namely -200%.
|