getting a percentage

  • Thread starter Thread starter noelf
  • Start date Start date
N

noelf

hi guys

need your help urgently

i need to calculate the percentage of apples from all other fruits
for example:

i have 8702 fruits in column a
and i have 2673 apples in column a

how do i calculate the percentage?

thanks in advanc
 
Fruit in A1
Apples in B1

Format C1 to percentage and enter this:
=B1/A1
30.72%

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

hi guys

need your help urgently

i need to calculate the percentage of apples from all other fruits
for example:

i have 8702 fruits in column a
and i have 2673 apples in column a

how do i calculate the percentage?

thanks in advance
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HDI: Show Value as 'Percentage of' Grouped Column in Pivot 2
Need help with Counting 1
Need running percentage in pivot table 1
is there a way to have 2 criterias for COUNTIF? 7
Circular reference help 3
Sorting multiple columns (fields) in a pivot table 1
Multi-column sort issue in Pivot Table 3
Calculated Item in a Pivot Table 2

Back
Top