Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
showing numbers as percentages
I need to create a column that shows the percentage for numbers that are in a
different column. I must be using the wrong formula because it only works if there is data in the "number" column. I need the formula to work prior to data being dropped into the "number" cells. As i am doing it I get an error message in each cell DIV/0! An example of one of the forumals I used is =B5/B10. B10 is the total i need to divide into B5, the part of the whole. An example of how I need it to look after the numbers are dropped into the worksheet Number Percentage Advanced 1 17% Mastery 2 33% Basic 3 50% --------------------------------------------------- Total 6 100% Any help is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
whole Numbers entered; percentages displayed. | Charts and Charting in Excel | |||
Frogs in the pond - percentages not numbers | Charts and Charting in Excel | |||
How do I change numbers and percentages in a formula?? | Excel Worksheet Functions | |||
Change percentages to numbers | Excel Worksheet Functions | |||
showing percentages in pie charts | Charts and Charting in Excel |