exact percentage of each cell
 

how do i get the exact percentage of each cell in a row of numbers from the
total row amount

exact percentage of each cell
 

Exact percentage? Can you post a sample of your data as it is now, and
describe what you would like to see?

Regards,
Ryan--
--
RyGuy


"lea" wrote:

how do i get the exact percentage of each cell in a row of numbers from the
total row amount

exact percentage of each cell
 

If your data is in A1:A10 and the SUM is in A11 enter the following in B1

=A1/$A$11

Right click on B1, select percentage. Now drag it down.

Is this what you want?


"lea" wrote in message
...
how do i get the exact percentage of each cell in a row of numbers from
the
total row amount

exact percentage of each cell
 

Thanks, that was great

"Gaurav" wrote:

If your data is in A1:A10 and the SUM is in A11 enter the following in B1

=A1/$A$11

Right click on B1, select percentage. Now drag it down.

Is this what you want?


"lea" wrote in message
...
how do i get the exact percentage of each cell in a row of numbers from
the
total row amount

exact percentage of each cell
 

You're welcome.


"lea" wrote in message
...
Thanks, that was great

"Gaurav" wrote:

If your data is in A1:A10 and the SUM is in A11 enter the following in B1

=A1/$A$11

Right click on B1, select percentage. Now drag it down.

Is this what you want?


"lea" wrote in message
...
how do i get the exact percentage of each cell in a row of numbers from
the
total row amount