Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Percentage function
Excel 2002 - Windows XP
Is there a function that will tell me the percent increase from one number to another? For example, if I have a 2004 salary and a 2005 salary and want to know what the percent increase is from 2004 to 2005, is there a function that will help me with this, or do I need to just do, good ole' fashion math. Thanks for your help, Jeff |
#2
|
|||
|
|||
=(2005-2004)/2004
format as percentage Regards, Peo Sjoblom "Jeff Bendert" wrote: Excel 2002 - Windows XP Is there a function that will tell me the percent increase from one number to another? For example, if I have a 2004 salary and a 2005 salary and want to know what the percent increase is from 2004 to 2005, is there a function that will help me with this, or do I need to just do, good ole' fashion math. Thanks for your help, Jeff |
#3
|
|||
|
|||
=(A2-A1)/A1
Format as % -- Kind Regards, Niek Otten Microsoft MVP - Excel "Jeff Bendert" wrote in message ... Excel 2002 - Windows XP Is there a function that will tell me the percent increase from one number to another? For example, if I have a 2004 salary and a 2005 salary and want to know what the percent increase is from 2004 to 2005, is there a function that will help me with this, or do I need to just do, good ole' fashion math. Thanks for your help, Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |