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.
I'm not sure what formaula to use to get the percentage?
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!
To calculate the percentage of the grand total for each type of office supply in column F (cell ranges F5:F16), you need to use the following formula:
`=B5/$B$17`
Here's an explanation of the formula:
1. `B5` represents the value for each type of office supply. This value will be divided by the grand total.
2. `$B$17` represents the grand total value, which is the total sum of all the office supply values.
To apply the formula to the range F5:F16, follow these steps:
1. Select the cell F5.
2. Type the formula `=B5/$B$17`.
3. Press Enter.
Now, copy the formula to the remaining cells in the range F5:F16. There are a few ways to do this:
1. Manual Method: Select cell F5, then click and drag the fill handle (a small square in the bottom-right corner of the cell) down to cell F16. Release the mouse button to fill the cells with the formula.
2. Shortcut Method: After entering the formula in cell F5, select cell F5. Press and hold the Ctrl key, then press the letter "C" to copy the formula. Then, select the range F6:F16 and press Ctrl+V to paste the formula into all the selected cells at once.
To format the results in the Percentage style with no decimal places:
1. Select the range F5:F16.
2. Right-click and choose Format Cells from the context menu.
3. In the Format Cells dialog box, select the Percentage category on the left.
4. In the Decimal places field, enter 0 to round the results to the nearest whole percent.
5. Click OK to apply the formatting to the selected range.
Now, the range F5:F16 will display the percentage of the grand total for each type of office supply, rounded to the nearest whole percent.