Posted by kayla on Tuesday, May 31, 2011 at 6:20pm.
http://search.avg.com/route/?d=4cbfb155&v=7.004.022.004&i=23&tp=chrome&q=excel+tutorial&lng=en-US&iy=&ychte=us
Choose one of the tutorials here, depending on the version of Excel you have.
Im trying to find the percent of a grand total.
Total cost 74.75,cost/unit 2.99, number of units 25
I'm still don't understand how to get the percent ive tried everything i divided 2.99/74.85 and got 4% but the answer is 14% they give you the answer but i have to show the formaula i used to get 14 and i don't know how please help.
I do not know what numbers are shown in column F (F5 to F16).
Assume for the moment F5:F8 shows:
F G
10 12%
18 21%
32 38%
24 29%
83 100%
83 is the grand total
12% is obtained by dividing 10 by 83, or
+F5/F$9 (assume the grand total is in F9) The "$" is necessary because G5=+F5/F$9, and G6=+F6/F$9, ...
Hope that helps. If you have questions, please post the contents of F6:F16 as example for discussion.
the answer they gave me was 14% and i am suppose to figure out the formula but i still cant i did 2.99/521.07< which is the grand total at the end of column f16 i still did not get 14
In cell E18, use an appropriate formula to calculate the grand
total of column E. Format the result in the Currency style.
In column F (cell ranges F5:F16), use an appropriate formula
to calculate the percentage of the grand total for each type of
office supply. Format the results in the Percentage style. If
necessary, decrease the decimal places to round the results
to the nearest whole percent.
In cell F18, use an appropriate formula to calculate the total
percentage. Format the result in the Percentage style and
decrease the decimal places if necessary to round the result
to the nearest whole percent. (Obviously, the result should
equal 100%.)
Repeat these procedures for column J (Total Cost) and column
K (% of Grand Total) for the month of February. (Place
the grand total of column J in cell J18 and the grand total of
column K in cell K18.) Again, remember to use formulas.
I still do not see the contents of cells E5:E16, so I cannot confirm how the 14% answer can be obtained.
On the other hand, if you would calculate the previous cost $74.75/grandtotal=521.07, you'd get 14.3%, or, 14% rounded to the nearest percent.
What needs to be done is to calculate E18 as +sum(E5:E18).
Then in the cell F5, calculate the percentage by the formula +E5/E$18. The extra dollar sign between E and 18 is to "fix" the cell number 18 when you copy the cell F5 to other rows.
After that, you would copy the cell F5 to each of the cells F6:F16, and F18.
You should see 1.00 in cell F18. We need now to change the cells in column F to percentages in whole numbers. Format the column F and select type as "percentage", and the number of decimal places as 0.
If you succeed in doing the above, you should have no problem with other columns.
Post if you need further help.
Thank you so much i think i've got it
You're welcome!