Currently I am working on an assignment and need to turn a whole column
(approx. 153 cells) into a individual percentages of one cell. Every time I
tried to use a formula I either got 0 or DIV#0. I was wondering if there was
a formula I could create on my own so that I can drag thru the entire column.
I even tried to fool around with the '$' in the cells and that was
unsuccessful. I was also wondering if it had to do with the fact the numbers
in the cell also originate from formulas? Thanks


Sample #s and they need to be %s of 14,500,698

1,400,000
870,000
590,000
565,000
470,000
439,000
429,650
425,000
424,791
419,475
383,000
342,500
315,000
300,000
275,000
259,167
235,000
235,000
229,938
220,000
210,000
196,000
190,000
180,000
177,000
176,800
170,000
158,333
150,000
140,631
130,000
125,000
120,000
116,000
109,000
100,000
100,000
100,000
90,000
90,000
90,000
80,000
80,000
80,000
80,000
75,000
75,000
75,000
70,000


MeursaultO

If your numbers are in column A, and your total is at the bottom in A50, in
B1, put:
=a1/a$50
Format as a percentage.
Drag down to B49

Regards,
Fred

"MeursaultO" wrote in message
...
Currently I am working on an assignment and need to turn a whole column
(approx. 153 cells) into a individual percentages of one cell. Every time
I
tried to use a formula I either got 0 or DIV#0. I was wondering if there
was
a formula I could create on my own so that I can drag thru the entire
column.
I even tried to fool around with the '$' in the cells and that was
unsuccessful. I was also wondering if it had to do with the fact the
numbers
in the cell also originate from formulas? Thanks


Sample #s and they need to be %s of 14,500,698

1,400,000
870,000
590,000
565,000
470,000
439,000
429,650
425,000
424,791
419,475
383,000
342,500
315,000
300,000
275,000
259,167
235,000
235,000
229,938
220,000
210,000
196,000
190,000
180,000
177,000
176,800
170,000
158,333
150,000
140,631
130,000
125,000
120,000
116,000
109,000
100,000
100,000
100,000
90,000
90,000
90,000
80,000
80,000
80,000
80,000
75,000
75,000
75,000
70,000


MeursaultO

I don't think that MeursaultO was meaning what percentage of the total column
each constituent part is.

He asks what percentage of 14,500,698 "in a given cell" each entry is.

The total of the column is not that figure (it's 12,361,285).
I accept that he's given "sample" numbers but he is clear about the given
cell figure.

So, the way I interpret it the solution is;

If data is in col A. Calc is in col B. Given cell is C1 (14500698)

In B1 place =A1/$C$1%

Drag down

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Fred Smith" wrote:

If your numbers are in column A, and your total is at the bottom in A50, in
B1, put:
=a1/a$50
Format as a percentage.
Drag down to B49

Regards,
Fred

"MeursaultO" wrote in message
...
Currently I am working on an assignment and need to turn a whole column
(approx. 153 cells) into a individual percentages of one cell. Every time
I
tried to use a formula I either got 0 or DIV#0. I was wondering if there
was
a formula I could create on my own so that I can drag thru the entire
column.
I even tried to fool around with the '$' in the cells and that was
unsuccessful. I was also wondering if it had to do with the fact the
numbers
in the cell also originate from formulas? Thanks


Sample #s and they need to be %s of 14,500,698

1,400,000
870,000
590,000
565,000
470,000
439,000
429,650
425,000
424,791
419,475
383,000
342,500
315,000
300,000
275,000
259,167
235,000
235,000
229,938
220,000
210,000
196,000
190,000
180,000
177,000
176,800
170,000
158,333
150,000
140,631
130,000
125,000
120,000
116,000
109,000
100,000
100,000
100,000
90,000
90,000
90,000
80,000
80,000
80,000
80,000
75,000
75,000
75,000
70,000


MeursaultO

.

Hi,

You could try this

Type 14500698 in a cell, say M1. In N1, type =$M$1. Copy N1 and go to Edit
Paste Special Divide.

Hope this helps

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"MeursaultO" wrote in message
...
Currently I am working on an assignment and need to turn a whole column
(approx. 153 cells) into a individual percentages of one cell. Every time
I
tried to use a formula I either got 0 or DIV#0. I was wondering if there
was
a formula I could create on my own so that I can drag thru the entire
column.
I even tried to fool around with the '$' in the cells and that was
unsuccessful. I was also wondering if it had to do with the fact the
numbers
in the cell also originate from formulas? Thanks


Sample #s and they need to be %s of 14,500,698

1,400,000
870,000
590,000
565,000
470,000
439,000
429,650
425,000
424,791
419,475
383,000
342,500
315,000
300,000
275,000
259,167
235,000
235,000
229,938
220,000
210,000
196,000
190,000
180,000
177,000
176,800
170,000
158,333
150,000
140,631
130,000
125,000
120,000
116,000
109,000
100,000
100,000
100,000
90,000
90,000
90,000
80,000
80,000
80,000
80,000
75,000
75,000
75,000
70,000


MeursaultO