Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" wrote in message ... 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" wrote in message ... 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" wrote in message ... 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" wrote in message ... 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random #'s for a population | Excel Discussion (Misc queries) | |||
Automatic Population | Excel Discussion (Misc queries) | |||
How do i get a chart showing the demographics of a country? | Charts and Charting in Excel | |||
Field Population | Excel Discussion (Misc queries) | |||
combobox population | Excel Programming |