• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Consolidate the Results > Calculate Percent Diff

Calculate Percent Diff

When we created our consolidation, we omitted the percent difference calculation on the source worksheets. The reason: Our consolidation used the SUM function to add values in the source worksheets. Adding the percentages would result in incorrect values for the consolidated percent differences. As a result, we need to recreate the percent difference formula in the consolidation worksheet and copy it to the appropriate cells.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint