Saturday

January 21, 2017
Posted by **kayla** on Tuesday, May 31, 2011 at 6:20pm.

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.

I'm not sure what formaula to use to get the percentage?

- excel graphing -
**Writeacher**, Tuesday, May 31, 2011 at 6:46pmhttp://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. - excel graphing -
**kayla**, Tuesday, May 31, 2011 at 7:25pmIm 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. - excel graphing -
**MathMate**, Tuesday, May 31, 2011 at 10:01pmI 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. - F6:F16 -
**KAYLA**, Wednesday, June 1, 2011 at 12:21pmthe 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

- excel graphing -
**KAYLA**, Wednesday, June 1, 2011 at 12:28pmIn 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. - excel graphing -
**MathMate**, Wednesday, June 1, 2011 at 10:37pmI 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. - excel graphing -
**KAYLA**, Sunday, June 5, 2011 at 11:47amThank you so much i think i've got it

- excel graphing -
**MathMate**, Sunday, June 5, 2011 at 4:20pmYou're welcome!