FIGURE 1 FIGURE 2 SOFTWARE FIGURE 3 FIGURE 4 FIGURE 5 leaving the column reference relative. The percentage increase or decrease varies by year for each location and is stored in row 30, so the formula in the highlighted cell, D32, is =C32*(1+D$30). As this formula is copied throughout the table, the formula references the increase or decrease, which is an absolute reference to row 30. The ability to fluently use relative, absolute, and mixed references in formulas adds a tremendous amount of flexibility to spreadsheets. Relative, absolute, and mixed references can also be used in functions, making the functions more powerful, as well. The ability to use one formula correctly throughout a spreadsheet, rather than having different versions of a formula to deal with absolute and mixed cell references, makes a spreadsheet more accurate and easier to maintain. The next time you can use an absolute or mixed cell reference in a formula, try it. You’ll be glad you did. ■ Nate Moore, CPA, MBA, FACMPE, writes custom SQL server code to mine practice management data for analysis in Excel, web pages, and via email. Nate’s first book, Better Data, Better Decisions: Using Business Intelligence in the Medical Practice, written with Mona Reimers, was recently published by MGMA. His free Excel videos have been viewed over one million times and are available at mooresolutionsinc.com. Like PivotTableGuy on Facebook or follow @PivotTableGuy on Twitter to be notified each time an Excel video is released. THE JOURNAL OF THE HEALTHCARE BILLING AND MANAGEMENT ASSOCIATION 37
Billing_MarApr15
To see the actual publication please follow the link above