Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default Index vs %

What's the difference between an index and percentage growth/decline?

Example: Last year's volume was 158 vs 2006's volume of 97. If I
divide 158 / 97 I get 162.9. Isn't that the same as 62.9%? Why would I
use one over the other and if I decide I don't want it to read 162.9,
just 62.9, how do I get that to happen?

Thanks.
 
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
How to use Index? Eric Excel Discussion (Misc queries) 1 October 5th 07 02:04 AM
Chart axes color index vs font color index [email protected] Charts and Charting in Excel 4 December 7th 06 04:05 PM
How do I pull the col. index value as well as row index value Vikram Dhemare Excel Discussion (Misc queries) 1 March 29th 06 07:48 AM
Index? HJ Excel Discussion (Misc queries) 8 February 9th 06 04:29 PM
Using INDEX twice?? Joe Gieder Excel Worksheet Functions 3 March 8th 05 01:21 PM


All times are GMT +1. The time now is 01:04 AM.

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

About Us

"It's about Microsoft Excel"