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

Chapter 10. Financial Functions > Excel in Practice

Excel in Practice

Notice the two examples of the COUPDAYS function in Figure 10.26. The first example uses cell referencing and the second hard codes the numbers in the formula. Whenever possible, use cell referencing with formulas so that your models or formulas remain dynamic. If you hard code numbers within formulas, you run the risk of error every time you want to update the numbers within the formula.

Figure 10.26. Use cell referencing whenever possible instead of hard coding numbers in formulas.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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