LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default Calclulating percentage difference

I have the following columns

Apr-2006 Apr 2007
0.00 0.00
0.00 0.00
0.00 331.08
0.00 107.90
0.00 0.00
0.00 970.00
1,134.60 0.00
0.00 2,587.59
5,999.06 16,294.34

I want to work out what the differnece is between 2006 and 2007 by
percentage ie is it a decrease of 25% or increase of 25%, what is the
formula for it?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentage of difference formula gallegos1580 Excel Discussion (Misc queries) 2 July 18th 06 06:52 PM
formula assistance - percentage difference Dave Excel Worksheet Functions 2 June 25th 06 04:00 AM
Finding the percentage difference of two or more numbers slr Excel Worksheet Functions 5 January 26th 06 02:00 PM
Percentage difference calc that knows the largest figure Mighty Magpie Excel Discussion (Misc queries) 3 November 10th 05 06:45 PM
percentage difference cimarron trucking New Users to Excel 3 December 8th 04 07:17 PM


All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"