Previous Topic Next Topic

EXCEL FORMULA FOR FINDING PERCENTAGE OF

Solved/Closed
LOLA - Feb 7, 2010 at 03:30 PM
 Blocked Profile - Apr 27, 2010 at 01:47 AM
Hello, I need a simple formaul for finding the percentage of

Total number of members: answer in column A392
Total number of members who have provided requested info: answer in column K392

Please help me with this formula....if I'm ask what percent of the members have provided requested info?
Related:

2 replies

Answer 1 / 2
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 9, 2010 at 03:54 PM
= 100 * K392 / A392

or you can use

= K392 / A392 and format the cell to be a %age
146
Answer 2 / 2
Blocked Profile
Apr 27, 2010 at 01:47 AM
If $2000.00 is in say C1 and $50.00 for Cable TV in C2, then
you can use say in D2:

=C2/$C$1

and format D2 in Percent Style via Format Toolbar.

Is this what you're looking for?
29