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?

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Percentage Work
Winndixie -
RayH -

6 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response