Home » Category » Microsoft Excel

Microsoft Excel: Yr to Yr comparisons

205| Thu, 22 May 2008 21:36:00 GMT| anonymous| Comments (3)
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.

Keywords & Tags: yr, comparisons, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/494862/
 
«« Prev - Next »» 3 helpful answers below.
=(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.

peosjoblom | Thu, 22 May 2008 21:37:00 GMT |

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.

cisse5 | Thu, 22 May 2008 21:38:00 GMT |

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.

michael | Thu, 22 May 2008 21:39:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories