Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jane P.
 
Posts: n/a
Default how to state result of current yr/last yr % increase/decrease

When prior year volume = 0, and this year volume = 10, what is correct way to
state percentage increase/decrease?
--
Jane P
  #2   Report Post  
DNA
 
Posts: n/a
Default

Percent change is:

100 (x-y)/y

So, that's x-y/y*100

Percent total is:

100 (x/y)

So, that's x/y*100

HTH

  #3   Report Post  
Jane P.
 
Posts: n/a
Default

I might be doing something wrong, but that formula doesn't seem to be
working.

this yr = 10
last yr = 0
increase = 10
% of increase over last year = WHAT? (how is WHAT stated as a %? 100% or is
100% only valid if last year had a value other than zero?
--
Jane P


"DNA" wrote:

Percent change is:

100 (x-y)/y

So, that's x-y/y*100

Percent total is:

100 (x/y)

So, that's x/y*100

HTH


  #4   Report Post  
DNA
 
Posts: n/a
Default

Lets think this thru, the zero might be getting you. This is how to calc
percent increase.

Let's say an automobile you wanted to buy was $20,000, but now you see it
has increased to $25,000, what is the percent increase.

First find absolute increase:

25000-20000=5000

The percentage increase is the relative change:

5000/20000=.25

Hope this helps at least the thought process.



Reply
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
I NEED HELP with the SPELLNUMBER Function vag Excel Worksheet Functions 0 June 21st 05 08:17 AM
EXCEL:NUMBER TO GREEK WORDS vag Excel Worksheet Functions 1 June 15th 05 05:57 PM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
Is there a formula to spell out a number in excel? Sha-nay-nay Excel Worksheet Functions 2 December 18th 04 09:25 PM
Spellnumber Norman Jones Excel Worksheet Functions 6 December 13th 04 07:21 AM


All times are GMT +1. The time now is 06:24 PM.

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"