Thread: need formula 4 %change on both neg and pos movemnt year to year co
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
suesolotel suesolotel is offline
external usenet poster
  
Posts: 5
Default need formula 4 %change on both neg and pos movemnt year to year co
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