View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default How do i calculate the percentage to compare two different years

Please use this white space to elaborate on your question. You limit the
people who can respond to your question when you use only the subject line.

Do you want the percentage difference? If so, try:
A1: Last year's number
B1: This year's number
%diff: = (b1-a1)/a1
Format as percent

Regards,
Fred

"baba" wrote in message
...