ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do i calculate the percentage to compare two different years (https://www.excelbanter.com/excel-worksheet-functions/256602-how-do-i-calculate-percentage-compare-two-different-years.html)

Baba

How do i calculate the percentage to compare two different years
 


Fred Smith[_4_]

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
...




All times are GMT +1. The time now is 03:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com