Now hit the F4 function key on your keyboard. This cell has to be set as an absolute cell reference so that when you have calculated the result for Store 1, you can use the fill handle to work out the percentage turnover for the other stores. Finally, press the enter key, or click the tick by the left of the formula bar, to finish the formula. Type a percent sign ( %) to instruct Excel that this is a percentage calculation. Now type a division sign ( /) followed by the cell reference of the total turnover, G10. Alternatively, after typing in the equals sign, you could click in G5, or navigate to G5 using the cursor keys. Type an equals sign =, then type in the cell reference of the first cell to be used in the calculation, in this case G5. (To calculate what percentage 5 is of 25 you would divide 5 by 25, which is 0.2, and then multiply it by 100, giving an answer of 20%.) You need to divide H5, the 2006 Store 1 turnover, by cell G10, the total turnover of all five stores. In the example shown, you want to calculate what percentage the 2006 Turnover in Store 1 was of Total 2006 figures. Open a workbook with figures that need percentages and click in the cell where you want your answer. You may have to work out the sales in each store as a percentage of the total sales over all stores.
0 Comments
Leave a Reply. |