Thread: Net change and percentage of change
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Net change and percentage of change
=(B1-A1)/B1


"Richard" wrote:

Hi,

I have a list of parts that have had price increases. One column has the old
price the other has the new price. I need to show the difference, whether it
is positive or negative and the percentage of the increase or decrease. The
difference is not a problem. The problem lies in calculating the percentage.
I don't how to do that. Can someone tell me?

Thanks,
Richard
Reply With QuoteReply With Quote