Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use a percentage formula?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage Formula | Excel Worksheet Functions | |||
Percentage Formula Help | Excel Worksheet Functions | |||
Percentage Formula | Excel Discussion (Misc queries) | |||
percentage formula | Excel Worksheet Functions | |||
Percentage Formula | Excel Worksheet Functions |