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.
|