getting a percentage

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
 
R

RagDyer

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
 
Top