Tuesday, October 6, 2009

forex live

The numbers should now be correct. Point to cells D25, E25, F25 and G25 (like you did before). You will notice the "$'s" have copied the =$C$23 to each cell (absoluting) and the Net Income figures have rolled as they should. Absoluting is something you should know and understand.Pause and reflect Look at all you have accomplished. If you want go in and change some more numbers or change the income and expense titles to something you feel is more fun or appropriate, please do so.This would be a great time to Save again.0 comments Read More... at 2:08 AM Microsoft Excel 2003: Copying Percentage FormulaNotice 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 rightThis would be a great time to Save again.

No comments:

Post a Comment