Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
When prior year volume = 0, and this year volume = 10, what is correct way to
state percentage increase/decrease? -- Jane P |
#2
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |