A1 = $1,200,359
B1 = $2,529,259
C1 = (B1-A1)/A1 = ($2,529,259 - $1,200,359)/$1,200,359 = 110.71%
Format as a percent.
--
Sincerely, Michael Colvin


"cisse_5" wrote:

I am actually looking for the percentage % increase or decrease not the
difference which is what I think I received.

"Peo Sjoblom" wrote:

=(B1-A1)/A1

Regards,

Peo Sjoblom

"cisse_5" wrote:

After years of being in a high level tech support position, I transferred to
a Business Analyst position. I forgot the formula used to provide the
percentage increase or decrease this year compared to last year.

2003 2004
1,200,359 2,529,259

What is the percent increase in sales from 2003 to 2004?

A3 = the first figure and cell G3 equals the second sales figure. I tried
1,200,359/2.529,259 but am not getting the correct percentage or percent
formatting in Excel 2003.