View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LEA LEA is offline
external usenet poster
 
Posts: 9
Default 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