Sunday, July 26, 2009

Copying the Percentage Formula

Notice that we didn't copy the percentage formula when we did the last copying process. If we had copied a sum formula, it would have added teh four percentages. we don't want the sum of the percentages . we want a percentage of only applies to the overall monthly totals. so , we need to copy the percentage formula separately . Click on cell f21 copy the percentage formula in cell r21 to cell g21 . This is the average percentage that Income is greater than Expenses .

No comments:

Post a Comment