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

Chapter 7. Database Functions > Excel in Practice

Excel in Practice

When structuring your database and criteria, be sure to create a logical set to allow for dynamically changing the criteria. Notice the example in Figure 7.9. By changing the criteria in cells C14:D15, the result of the DAVERAGE function in cell F14 changes. You should use dynamic cell referencing instead of hard coding as shown in cell F20.

Figure 7.9. As a rule, remember to use cell referencing in formulas instead of hard coding; this makes your formula dynamic based on the criteria.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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