Notice that we didn’t copy the percentage formula when we started this last copying effort. If we had copied a SUM formula, it would have added the four percentages. We don’t want the sum of the percentages. We want a percentage of just the Monthly Totals. So, we need to copy this percentage separately. Now, copy the percentage formula in cell F21 to cell G21. Now put a $ in cells G6 through G19 if you need to, and a % in G21. Your spreadsheet column G should look something like the image on the right
This would be a great time to Save again.
Microsoft Excel 2003: Copying Percentage Formula
Labels: Microsoft Excel 2003 |
Subscribe to:
Post Comments (Atom)
1 Comentário:
Yesterday evening I had unpleasant situation.Some of very important excel files were damaged no one knew how.But a friend advised me-Excel file repair software.And program solved this problem very easy and without payment.Moreover I saw how utility recovered contents and export of recovered data into a new document in Microsoft Excel format.
Post a Comment