EXCEL FORMULA FOR FINDING PERCENTAGE OF [Solved/Closed]

Report
-
 Blocked Profile -
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?

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
763
= 100 * K392 / A392

or you can use

= K392 / A392 and format the cell to be a %age
146
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month


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?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!