kimchicowboy

i have a bunch of data regarding ethnic population sizes per zip code, i.e. total population under column B, hispanic poopulation under column D, etc. i'm trying to find percentages of each population (hispanic population/total population) how can i have it so that under like column G, excel will automatically divide all column D items by column B items? thanks!

popicon88

Can you either post the document or send me the document so I can see what you're talking about?

topane

I'm not sure I follow what the problem is. Do you want to have a formula in a cell in column G? If you're dividing D by B then all you have to do is fill in the correct cells (D2/B2, D3/B3, etc). If you're looking for an easy way to fill in a bunch of cells without typing a formula over and over you can use Excel's drag and fill features.

[edited to add]
If you could post a couple pieces of example data, that would be extremetly helpful.

__________________
Shall we buy a new guitar?
Shall we drive a more powerful car?

kimchicowboy

for example:

D2's cell is: 38070 (hispanic population for zip code 90001)
B2's cell is: 51635 (total population for zip code 90001)

i just popped in 38070/51635 into my calculator and got 74%, which i put into cell G2. does that help? if not, e-mail me at: zookie43@yahoo.com and i can e-mail the document to you (i don[t know how to host it online)

thanks guys!

ramazank2

In the cell G2 you need to type: =D2/B2

Dont forget the =.

The in the lower left hand corner of the G2 cell you drag it all the way down G to which ever cell you want so then G3 will do D3/B3 and so on.

Also you dont have to type the cells. You can type = then click on D2 then type / then click on B2 then press enter.

I will do it for you if email me the document at ramazank2@juno.com