Thread: need formula 4 %change on both neg and pos movemnt year to year co
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default need formula 4 %change on both neg and pos movemnt year to year co
1. Post your formula.
2. Explain what (-12074) is. Is this negative 12,074 or positive 12,074?

Regards,
Fred

"suesolotel" wrote in message
...
i need to have a formula that will calculate % change for loss to profit
and
profit to loss and profit to profit

(16968) (-12074) = 28.8% increase
(12074) 5582 = 146.2% increase
my formula is showing 28.8 decrease and -146.2 decrease
can tseem to get one formula that will account for movement both ways

Reply With QuoteReply With Quote