# Excell and Population demographics

1. ## Excell and Population demographics

I am trying to create a spread sheet showing population changes. For one of
my lists I show a change in population from 194 in 1990 to 962 in 2000. The
data source reports this is a 396% increase. How do I format the cells, B2
to C2, to show this figure automatically as I have a whole list (B3 to C3,
etc) of different counties to figure.
--
Jeffery

2. ## Re: Excell and Population demographics

B1: 194
B2: 962
In C2 put in
=(B2-B1)/B1
and format the Cell as Per centage with no decimals.

then select C2 and drag fill down the sheet.

--
Regards,
Tom Ogilvy

"Jeffery" <Jeffery@discussions.microsoft.com> wrote in message
news:1CA2997A-8A5E-414F-9A0C-10BB26E3ABBB@microsoft.com...
> I am trying to create a spread sheet showing population changes. For one

of
> my lists I show a change in population from 194 in 1990 to 962 in 2000.

The
> data source reports this is a 396% increase. How do I format the cells,

B2
> to C2, to show this figure automatically as I have a whole list (B3 to C3,
> etc) of different counties to figure.
> --
> Jeffery

3. ## Re: Excell and Population demographics

Thank Tom.

This did get me close. My inital population in 1990 was 194 in B2. In 2000
was 962 in C2. Need the percentage in D2. Putting in the formula you gave
me I got the answer, but it's in a negative percentage showing it decreased
instead of increased. How can I reflect it as an increase?
--
Jeffery

"Tom Ogilvy" wrote:

> B1: 194
> B2: 962
> In C2 put in
> =(B2-B1)/B1
> and format the Cell as Per centage with no decimals.
>
> then select C2 and drag fill down the sheet.
>
> --
> Regards,
> Tom Ogilvy
>
> "Jeffery" <Jeffery@discussions.microsoft.com> wrote in message
> news:1CA2997A-8A5E-414F-9A0C-10BB26E3ABBB@microsoft.com...
> > I am trying to create a spread sheet showing population changes. For one

> of
> > my lists I show a change in population from 194 in 1990 to 962 in 2000.

> The
> > data source reports this is a 396% increase. How do I format the cells,

> B2
> > to C2, to show this figure automatically as I have a whole list (B3 to C3,
> > etc) of different counties to figure.
> > --
> > Jeffery

>
>
>

4. ## Re: Excell and Population demographics

I believe it is clear that I misinterpreted your locations if you would
compare what I provided. Here is a correction:

B2: 194
C2: 962
In D2 put in
=(C2-B2)/B2
format as Percentage with no decimals.

Then drag fill down column
--
Regards,
Tom Ogilvy

"Jeffery" <Jeffery@discussions.microsoft.com> wrote in message
news:51460D73-0C52-4738-A586-FA4E6756F960@microsoft.com...
> Thank Tom.
>
> This did get me close. My inital population in 1990 was 194 in B2. In

2000
> was 962 in C2. Need the percentage in D2. Putting in the formula you

gave
> me I got the answer, but it's in a negative percentage showing it

decreased
> instead of increased. How can I reflect it as an increase?
> --
> Jeffery
>
>
> "Tom Ogilvy" wrote:
>
> > B1: 194
> > B2: 962
> > In C2 put in
> > =(B2-B1)/B1
> > and format the Cell as Per centage with no decimals.
> >
> > then select C2 and drag fill down the sheet.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Jeffery" <Jeffery@discussions.microsoft.com> wrote in message
> > news:1CA2997A-8A5E-414F-9A0C-10BB26E3ABBB@microsoft.com...
> > > I am trying to create a spread sheet showing population changes. For

one
> > of
> > > my lists I show a change in population from 194 in 1990 to 962 in

2000.
> > The
> > > data source reports this is a 396% increase. How do I format the

cells,
> > B2
> > > to C2, to show this figure automatically as I have a whole list (B3 to

C3,
> > > etc) of different counties to figure.
> > > --
> > > Jeffery

> >
> >
> >

5. ## Re: Excell and Population demographics

Thanks Tom. Wow.... in a 14 year period in the ten rural Missouri counties
that Tyson built meat processing plants there was a 736% increase in the
Hispanic population with only an 18% "all other" population increase.... go
figure.
--
Jeffery
--
Jeffery

"Tom Ogilvy" wrote:

> I believe it is clear that I misinterpreted your locations if you would
> compare what I provided. Here is a correction:
>
> B2: 194
> C2: 962
> In D2 put in
> =(C2-B2)/B2
> format as Percentage with no decimals.
>
> Then drag fill down column
> --
> Regards,
> Tom Ogilvy
>
>
>
> "Jeffery" <Jeffery@discussions.microsoft.com> wrote in message
> news:51460D73-0C52-4738-A586-FA4E6756F960@microsoft.com...
> > Thank Tom.
> >
> > This did get me close. My inital population in 1990 was 194 in B2. In

> 2000
> > was 962 in C2. Need the percentage in D2. Putting in the formula you

> gave
> > me I got the answer, but it's in a negative percentage showing it

> decreased
> > instead of increased. How can I reflect it as an increase?
> > --
> > Jeffery
> >
> >
> > "Tom Ogilvy" wrote:
> >
> > > B1: 194
> > > B2: 962
> > > In C2 put in
> > > =(B2-B1)/B1
> > > and format the Cell as Per centage with no decimals.
> > >
> > > then select C2 and drag fill down the sheet.
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "Jeffery" <Jeffery@discussions.microsoft.com> wrote in message
> > > news:1CA2997A-8A5E-414F-9A0C-10BB26E3ABBB@microsoft.com...
> > > > I am trying to create a spread sheet showing population changes. For

> one
> > > of
> > > > my lists I show a change in population from 194 in 1990 to 962 in

> 2000.
> > > The
> > > > data source reports this is a 396% increase. How do I format the

> cells,
> > > B2
> > > > to C2, to show this figure automatically as I have a whole list (B3 to

> C3,
> > > > etc) of different counties to figure.
> > > > --
> > > > Jeffery
> > >
> > >
> > >

>
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1