M
MeursaultO
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
(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