# how do i get annual percentage difference reports in excel

=?Utf-8?B?bWl0Y2g=?=
Guest
Posts: n/a

 5th Jul 2005
i'm looking to compare two sets of figures for year on year accounts and
would like to ahve the percentage difference calculated whether it be
positive or negative, i.e. whether sales have increased or fallen on that
week compared to the same week last year.

i could do this with a calculator and do it manually but i have a lot of
data to crunch and need a helping hand

thanks

Ian
Guest
Posts: n/a

 5th Jul 2005
=(Thisyearcellref-Lastyearcellref)/Lastyearcellref

Format the result as %

"mitch" <(E-Mail Removed)> wrote in message
news:E29EACEC-B7C0-4400-A6A3-(E-Mail Removed)...
> i'm looking to compare two sets of figures for year on year accounts and
> would like to ahve the percentage difference calculated whether it be
> positive or negative, i.e. whether sales have increased or fallen on that
> week compared to the same week last year.
>
> i could do this with a calculator and do it manually but i have a lot of
> data to crunch and need a helping hand
>
> thanks

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?TGlzYSBN?= Microsoft Excel Worksheet Functions 29 27th Jul 2007 03:55 AM =?Utf-8?B?S0M=?= Microsoft Excel Worksheet Functions 1 8th May 2006 05:36 AM =?Utf-8?B?VHJpc3Rhbg==?= Microsoft Excel Misc 3 5th Feb 2005 05:37 PM =?Utf-8?B?c3RzMTEx?= Microsoft Excel Misc 1 1st Feb 2005 02:26 PM JB Microsoft Excel Programming 0 21st Apr 2004 04:55 PM

Features

Newsgroups

All times are GMT +1. The time now is 10:25 PM.