how do i get the exact percentage of each cell in a row of numbers from the total row amount
L lea Apr 30, 2008 #1 how do i get the exact percentage of each cell in a row of numbers from the total row amount
R ryguy7272 Apr 30, 2008 #2 Exact percentage? Can you post a sample of your data as it is now, and describe what you would like to see? Regards, Ryan--
Exact percentage? Can you post a sample of your data as it is now, and describe what you would like to see? Regards, Ryan--
G Gaurav Apr 30, 2008 #3 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?
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?
L lea Apr 30, 2008 #4 Thanks, that was great Gaurav said: 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? Click to expand...
Thanks, that was great Gaurav said: 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? Click to expand...