Previous Topic Next Topic

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

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

or you can use

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

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

CCM 2942 users have said thank you to us this month

Answer 2 / 2

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?
Ask a question