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

=(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

=(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