View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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%.