Is there anybody here working with excel spread sheets, that could que me in on a function I can't seem to find? I'm trying to find, in a column of cells, the average number of cells that are occupied........in a percentage format. For example: A column has 30 cells. 27 of those cells has something in them, 3 are empty. That column is 90% occupied.
AVG...averages the contents of the cells. COUNT....gives me the number of cells occupied (27)......but I can't figure out how to format that into 90%
I have the basic version of excel that comes with the MS Works bundle....7.0 I believe.
Thanks for any help.
AVG...averages the contents of the cells. COUNT....gives me the number of cells occupied (27)......but I can't figure out how to format that into 90%
I have the basic version of excel that comes with the MS Works bundle....7.0 I believe.
Thanks for any help.